Set Analysis is one of the most powerful features since it allows you to create your own subset independent of current selections. Although Set Analysis syntax is somewhat intimidating for a new Qlik developer, once you master the syntax, it opens a world of possibilities for custom solutions. That said, for a long time, set...Continue Reading
Three important visualizations or data storytelling aspects are quality, quantity, and manner. Quality = Data Quality Quantity = Data Volume and Required Number of Fields Manner = Using the most appropriate chart form for compelling storytelling For data quality in QlikView or Qlik Sense application, as a Qlik developer, you have to pay attention to...Continue Reading
I owe debt of gratitude to my friend, Dalton Ruer, for this blog post inspiration. He often writes about data context with his signature phrase — Context is King. That inspiration made me research useful functions that I can use for data brushing. Brushing is the process of interactively selecting data items from a visual representation....Continue Reading
CONCAT function is a lesser-known yet a powerful aggregation function. Since it is an aggregation function, you can use it in a Set Analysis expression. That opens up a world of possibilities for creative minds. In this blog post, I want to present a few good use cases to leverage the CONCAT function’s power. First,...Continue Reading
As you master QlikView or Qlik Sense, understanding how the script engine works under the hood will not only improve your ability to troubleshoot reload errors but also help you appreciate and marvel the power of the preceding load in your script. Let’s understand how the script load engine parses the script first. Then it...Continue Reading
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...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...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...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....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...Continue Reading