Download Set Analysis Primer

x

Category

QlikView
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
Both QlikView and Qlik Sense can interchangeably use QVD files. If you have QVD files created by QlikView and if you are embarking on Qlik Sense to develop new applications, you can leverage existing QVD files. That said, you may want to create a Qlik Sense application to show QVD metadata from all extract layer...
Continue Reading
Our goal with these short tips & trick videos is to shed light on the Qlik scripting and visualization concepts in a series of short videos. File Concatenation & Date Function How to Re-Use Master Items How to Set a Qlik Sense Default Page Peek() vs. Previous() Download ODAG Example QVF
Continue Reading
Last December, I had a plumbing problem at my home, so I hired a plumber based on his reviews. It turned out that the man was deft at other repair work too! “Why don’t you advertise as a handyman?” I asked. “Plumbers make more than a handyman,” he replied. Back in mid-nineties, I finished my...
Continue Reading
Many a times, I deal with a conundrum to create a table similar to a  manually formatted Excel, SSRS or BO report. One of the standard requirements I have seen is, “How can you show specific measures for certain dimension values and hide for certain dimension value?” For example, as shown in the depiction below,...
Continue Reading
Happy New Year! Let’s face it — many of Qlik developers know SQL. Is knowing SQL(Structured Query Language) essential to become a Qlik developer? Maybe. It’s a two-edged sword — SQL knowledge gives them a competitive advantage over someone who has no technical experience. Still, it can also pose some challenges when you want to...
Continue Reading
1 2