Set Analysis is a powerful set of syntax which is widely used in QlikView and Qlik Sense applications, but I find that many developers are unaware one of the most useful functions. Here I explain how to use it.
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.
Whilst not officially confirmed yet, we have heard from a number of sources that when the July price list comes out QlikView Small Business Edition Server will not be on it. This will make the entry level QlikView Enterprise Server – at four times the cost.
Over the years I have seen many QlikView apps, created by many different developers and analysts. Even now, I still come across apps where silly mistakes are made. Here is my list of things that really shouldn’t be happening in your apps – and how to fix them.