One of the techniques that I often use in QlikView is having dynamic dimensions and expressions working off of toggle buttons. This gives more flexibility than cycle expressions and cycle groups alone – particularly when you want to affect a number of charts at the same time. In QlikView this is straight forward, but in Qlik Sense it is less obvious, but this quick recipe shows how to do it.
At the beginning of last year I blogged on the differences between QlikView and Qlik Sense, using Lego as a metaphor. Returning to that theme I am looking at how things are progressing as Qlik Sense is maturing as a product, and more APIs are being exposed.
A few days after upgrading to Qlik Sense Desktop 3.0 SR1 I found that Sense was not running when clicking on it’s icon on the Taskbar. A task was starting, but no UI was appearing. I even tried re-installing without joy. The solution in the end was simple – but not at all obvious.
Quick Intelligence were long standing partners of Industrial Codebox and re-sellers of their QVSource product. At Qonnections this year it was announced that ICB were being purchased by Qlik. This month QVSource re-launched under the name Qlik Web Connectors, with a number of free ‘Standard’ connectors. In this post I look at some of what you can do with this product without licencing premium connectors.
Many blog posts and tutorials on Qlik Sense focus on the data visualisation features. The load script is often omitted maybe because the script is almost identical to the QlikView load script, of which much has already been written. This post highlights some of the techniques that are common to both products.
The implementation of variables and dollar sign expansion in QlikView and Qlik Sense is incredibly flexible and can be used to great effect in load scripts. In this post I show how and give a recipe for a NetworkDays function that excludes public holidays.