Download Set Analysis Primer

x

Blog

Stay up to date with Qlik
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
Have you ever wondered if you can perform ODAG on top of QVDs instead of going back to the database? If you have, then you are at the right place as we will see in this blog how this can be done using QVDs. If you are looking at this post, it is safe to assume you already know what ODAG is. If not, we encourage you to start from...
Continue Reading
Dixit’s last article on how to use parameterized variables in both QlikView and Qlik Sense generated a good bit of buzz. Many asked questions about nested parameterized variables. I thought of creating a sequel post to use new features in Qlik Sense April 2020 release to show how to nest parameterized variables using dollar-sign expansion. Qlik Sense April release has a new chart type: Button The button can also trigger...
Continue Reading
The parameterized variable is a simple functionality, but very powerful. I have used it in many projects where I see the requirement to create multiple metrics with small variance in the calculation. For example, calculate average orders over 30, 60, and 90 days. For this requirement, instead of creating three separate calculations, you can create a parameterized variable expression and pass 30, 60, and 90 as a parameter to a...
Continue Reading
1 2 3 4 5 8