Blog

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

Form Input and Commenting in Qlik

A common desire from Qlik customers over the years has been the ability to interactively edit data on a QV sheet and persist the changes in Qlik or maybe write back to another system. As Martin Mahler of VizLib describes it “turning a one-way data street into a two-way street”. Sometimes the ...
Read More

Install QS Document Analyzer on Server

Some people wish to run QS Document Analyzer (QSDA) on the Qlik Sense Enterprise server rather than Qlik Sense Desktop.  While the current installer only supports desktop, you can manually install to the server. QSDA installs three components; a connector, an application (qvf) and an extension. Install the latest QSDA on ...
Read More

Recipes for Qlikview Success