Qlikview

Recently we had data issue and few documents was affected by this. We notified the users by adding textboxes in these documents with a warning an explanation. But while this particular data issue was still active 2-3 more data issues was found and editing the text boxes was not quite an option. We didn’t had enough space in the main sheet there was no guarantee that the users will navigate straight to the main sheet editing all the documents, saving and publish them again was a bit slow process since the apps was few GB each in size For these reasons I’ve made a small QV extension that can show notifications which are setup in the server part of this solution ...

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. ...

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. ...

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.) ...

Every QlikView app have a section with available selections (usually on top or in the left side or both). This sections are static and are not visible all the time when the user scroll (if the tab contains more content which cannot fit on the visible screen). I was missing “fixed” selections areas in QlikView from time to time but never did anything about it. In desktop/IE plugin is not possible to have it but AJAX client is a different story. And the result is FixedContent. ...

If you have one Qlikview Access Point then you have no problems but when you have few Qlikview environments and multiple customers and want to open qv document then you are in trouble (kinda). Organizing bookmarks is one solutions that helps. I was thinking recently how to speed up the process of open document quickly and decided to make a little Chrome extension that will help. The idea of the extension is simple - define few Qlikview Access Points links and get the documents that are available. Then just search the list for document and jump in it. ...