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 —...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

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...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...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

Qlik Sense mashups are web pages that allow you to embed charts from various Qlik Sense applications. Users on a web page will have the same associative experience while interacting with charts. Mashups offer immense value if you have a web page with other content along with charts from Qlik Sense applications. With a set...Continue Reading

Last week I came across an interesting requirement to move an app from one server to another, including community sheets. Is it really possible? I was hoping that it is so I looked for a solution. Yes, you can do it. It’s straightforward, copy app binary, rename it and change the file extension to .qvf...Continue Reading

At times we come across Qlik Sense applications for which we do not have the underlying data, using which the dashboard has been developed. And we want to extract some or all the data tables from that application to be used for other use cases or dashboards. In such a case, create a table object...Continue Reading