Download Set Analysis Primer

x

Blog

Stay up to date with Qlik
If you are a Qlik developer, you know how to load data from Excel as it is a fairly straight forward process. But, what if you need to extract each sheet name as you load the respective table from Excel? Let’s explore the steps first. Load all tables first (All sheets within an Excel file)Loop through tables to extract sheet nameLoop through all the sheets from step 2 and add...
Continue Reading
With limited real estate, showing legend for each chart may not be a good idea, especially if you are trying to increase the data-ink. Data-ink was a term coined by Dr. Edward Tufte. The idea is to increase the number of pixels that tell the data stories effectively. One of the issues user face — in Qlik Sense — without a legend is to identify dimension value associated with a...
Continue Reading
As we all know, businesses love ad hoc reporting. Ad hoc reports empower the business users to create reports which caters to their needs. In this post I am not going to explain how this can be done in Qlik (as this has been explained in Customizable Straight Table by Jennell McIntire), but talk about one of the important settings where developers run into issues. Sometimes we have dimension/measure names...
Continue Reading
Most of us who have worked with both QlikView and Qlik Sense is aware of various aggregate functions that we can use in the script as well as charts. The family of functions known as aggregation functions consists of functions that take multiple field values as their input and return a single result, where the aggregation is defined by a chart dimension or a group by clause in the script. Aggregation functions...
Continue Reading
Our world has morphed into a world of hermits. Coronavirus pandemic has wreaked havoc globally, and it has been devastating for impoverished nations. So, while we are living like a hermit, why don’t we master a new skill and donate to make a difference in the lives of millions who are struggling during this terrible pandemic? An idea was born — let’s teach Qlik Sense in a full, one day...
Continue Reading
1 2 3 7