In this chapter, we will focus on the concept of Set Analysis and its use in Qlik Sense. We will cover the following topics:
- Cracking the syntax for Set Analysis
- Using flags in Set Analysis
- Using the
=
sign with variables in Set Analysis - Point in time using Set Analysis
- Using comparison sets in Set Analysis
- Using embedded functions in Set Analysis
- Creating a multi-measure expression in Set Analysis
- Using search strings inside a set modifier
- Capturing a list of field values using a
concat()
function in Set Analysis - Using the element functions
P()
andE()
in Set Analysis
I will say it outright that Set Analysis is one of the most important technical features of Qlik solutions. It allows you to do things dynamically that just won't be possible with the default selections you have made. Set analysis can be termed as Selection analysis. The user tells Qlik Sense what set of records need to be picked for calculation which is similar to making a selection...