Blog

qcb-qlik-sse, A General Purpose SSE

In Qlikview we have the ability to add function to the scripting language by writing VbScript in the document module (sometime called the “macro module”).  Typical  additions included regular expression matching & parsing, Qlik Sense does not have the module feature, but both Sense and QlikView share a similar feature,  Server Side ...
Read More

Load Master Items in Script?

At the Masters Summit for Qlik, I always try to show something new and cool.  At past events I’ve shown things like Alexa selections in Qlik Sense and the new Document Analyzer for Qlik Sense. So what do I have lined up for the upcoming Amsterdam and Washington DC events? In ...
Read More

Using JSON as HyperCube Data Payload

Summary: In this post I suggest a case for formatting measures as JSON to allow for easy consumption in an Engine-API webapp. In a recent customer webapp project with my partners at Websy, I found that using JSON for data in Qlik hypercubes was a useful technique. The app displays an overview of metrics collected throughout ...
Read More

A Common SSE Plugin Project

Summary: I introduce qcb-qlik-sse, a community Server Side Extension to share custom Qlik functions.  At the Masters Summit for Qlik, I dive into several different methods of creating reusable script and custom functions.  In QlikView we have the ability to write custom functions using VbScript/Jscript in the qvw Module. Custom ...
Read More

Script Interpretation and Evaluation

Summary: Qlik Script is both interpreted and evaluated. Understanding the meaning of these terms is useful in writing advanced script and understanding why some script “tricks” work and others don’t. In my Advanced Scripting session at the Masters Summit for Qlik, I sometimes begin with the question “What does $() ...
Read More

Recipes for Qlikview Success