Download Set Analysis Primer

x

By

Analytics Hub
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
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
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
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
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
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
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
One of the ways Qlik Sense differs from QlikView is how it handles security for user access to resources and data. Access to a resource — streams, apps, app objects, data connections — requires a security rule. Simply put, a security rule allows a user to perform an action on a resource provided that the...
Continue Reading
1 2 3