Couple of weeks back Alexander Karlsson (@mindspank) posted a tweet with idea for a new Qlik Sense extension. The extension should look like this: Basically the extension should have a rectangle for each state. The rectangles should be ordered so they will look like USA map. In each rectangle there should be two text values - top one is the state name in short format (WA, ID, MT etc.) and some value (user specified) ...
Recently I had a task to map set of ip addresses to country in Qlikview. I’ve found a nice dataset that can give me this link but the dataset was for ip range to country. For example: RangeFrom , RangeTo , Country 1.0.0.1, 1.10.0.1, US The solution I’ve come up with is to use IntervalMatch() function and map the ip list with the range. But the ip addresses are not a normal numeric so I need to convert it to numeric somehow. My solution is to make the following covertion: ...
We have a project in which we are working with menu navigation data (more like parent-child relation / hierarchical data). Although there are few approaches and solutions we’ve picked few visualisations that might be better to be used with our data. We had our POC app build in Qlikview using only QV charts and the solutions looked ok. But we’ve decided to spend more time in this and bring some D3 charts in QV. ...
After installing Qlikview extension I’m usually forgetting to check if the extension have new versions. From time to time I’m remembering to check but this is not on very regular basis. Last week I’ve started a new extension (more about it in the next couple of weeks) and gave the initial version to one of my colleagues for opinion. But to mail him every time when I release new version (especially in the active development phase) will be a bit annoying. So I’ve start to think if there a was to notify him more discreet that new version is there. ...
In Qlikview if there is a need to test/debug something developers are just creating some textboxes or straight/pivot tables right next to the dashboard (or in another sheet). In Qlik Sense it’s bit more tricky because the free space is kinda limited and if the need to check is on top of already fixed dashboard then some free space need to be made which involve some re-arrangement which I’m not big fan of. ...
Few months back I’ve needed a way to save Qlikivew table (during reload) to csv/txt file but without the field header (still cant remember the reason for this). But today I’ve saw that someone else is needing this so I’ve decided to solve this. The issue If we have the following script: RawTable: Load * Inline [ id, value 1 , 10 2 , 20 3 , 30 ]; Store RawTable Into CSVOutput.csv (txt); The output CSVOutput.csv file will look like this: ...
While waiting for my new and shiny Pebble Time I’ve finally managed to spend some time and play with Pebble API. And of course one of the first questions was is it possible to make a link between Pebble and Qlikview/Qlik Sense. Since I’m more familiar with Qlikview QMS API I’ve started with it. Limitations Display - since Pebble display is black and white showing charts is kinda obsolete (will check with the color Pebble Time display later). That’s why I’ve decided to try and show only number based reports. API - Qlikview API is limited when you try and get data from qvw. The only method I’ve found was to get specific field content. But think that this is enough since I don’t need complicated data. (Qlik Sense API on other side provide more options - building calculation on the fly, get data from objects etc.) Workflow The overall idea/workflow that worked for me is: ...
The Technology team asked me these days is it possible to provide them with live data who are the active qlikview users and which documents are accessed. This info is visible in the Management console but since our environment is a cluster with 3 QV servers if you want to check the active users you need to constantly click around to get the info. So I’ve ended making small c# console app that uses the Management API to extract this info in csv or json format and store the data in file. So now I can schedule the execution for the app and give Technology the link to the output file. ...
I’m missing the option to present Qlik Sense listboxes in a different ways (Not that I don’t like the default one I’m just missing it) So I’ve made an extension that can represent field values as Checkboxes, Radio buttons or Buttons. As you can see from the screenshots below few more options are available: Orientation: display the list as single row or multiple rows Toggle select: if “false” the behavior of the selection will be * more like “only one selected” option in Qlikview Active style (css): style the selected value(s) with valid CSS InActive style (css): style the non selected value(s) with valid CSS You can find the source code and the zip file in the Github repo ...
If you manage multiple Qlik servers (Qlikview or Sense) and need to access the management consoles multiple times per day you usually keep a list of servers urls somewhere (at least this is what I have). In this case opening this list every time or try to remember server url might be a bit frustrating sometimes. For this reason I’ve made a little Chrome packaged app that can help a little. The app itself is pretty simple. It is possible to add all the QMC urls and the app will display the selected server url in webview control The app will also generate shortcuts for all main QMC categories (like Source Documents, User Documents, Licenses etc.) ...