Qlik Sense

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

I like how flexible Qlik Sense is. With its massive API if we want we can re-build the GUI (and not only) from scratch and just use the background services (like the Engine or Repository). I have some (small) issues with how the current Hub looks and behaves and decided to build something simple that fits my needs. At the end I’ve wanted something simple that will provide me with quick search capabilities, few shortcuts and the options to create, delete and duplicate files. ...

At the moment VSCode is my preferred code editor (although I’m side using Atom sometimes as well). And when I’m writing something which uses qSocks I’ve always have GitHub and Qlik Sense help site open so I can check the available methods and what parameters need to be provided for these methods. Plus I’m a “bit” lazy and always copy/paste code from another projects I have and adapt it to the current needs. For these reasons I’ve made VSCode snippets extension. The extension is used from within VSCode and include all qSocks methods as snippets. Just type qsocck and pick the method that you need. ...

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

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