Qlik

Creating Qlik extensions/mashups is usually quite fun. But it will be better if you have a way to develop locally and deploy to Qlik. Usually I’m using qExt or sense-go but in this specific case I didn’t had the chance to use either (enterprise restrictions) Luckily for me Qlik-CLI was available. And Qlik-CLI is doing a great job dealing with Qlik Repository API. I’ve decided to write a small PowerShell script that can be used to import the extension from my local PC to Qlik. ...

With multi-stage Qlik environment (DEV, TEST, PROD etc) the load scripts are usually including some kind of a check - “In which environment am I?”. Based on the result different/additional actions might be performed. For example: if the environment is not PROD then mask/scramble the client names use different data connection names (providers) on each environment … It will be nice if there is something more centralised that can provide this information (and not only) to any app on the cluster. Something like a global meta-data “storage” that can be changed/updated (by the administrators) ...

One feature that is missing in Qlik Sense is to send mail notifications when task is completed (fail or success). This feature is available in QlikView Server and I’m finding it very useful. I’ve found 3 ways that this can be achieved in QS: Log files scraping QRS API log4net I’ll cover the third option in details Log files Every QS service have it’s own log folder where the activity is logged. Batch file can be written that monitor the Scheduler service log file and on change to scrap the content and mail the result. ...

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

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

I’ve started playing with Qlik Sense extensions these days and pretty much I’m happy with the process in overall. You can develop extensions using Workbench (if you have Qlik Sense Desktop installed) or any text editor. But if you have Sense Server installed you need to develop directly on the server or upload your files every time a change is made. From 7-8 months I’m a proud owner of Chromebook and I’m trying to use it as many as possible. At this point I can use it as my default laptop for work. ...