What You Will Learn!
- What are the Set Analysis Components?
- How to use Dollar sign and Double Dollar sign?
- What is Point in Time reporting and how to achieve this using Set Analysis?
- How to use Set Analysis with Bookmarks?
- How to do comparative analysis using Set Analysis and Alternate State?
- How powerful indirect Set Analysis is, with the use of P() and E()?
- How to use Variables in Set Analysis?
- How to handle null values in Set Analysis?
- How to use Aggr(), FirstSortedValue() and Concat() functions along with Set Analysis?
Description
Set Analysis is a powerful function of Qlik using which one can write complex expressions easiest way. Issue is, the syntax of this function is overwhelming and student need to have lot of patience to be a master of it.
In this video tutorial, I tried to cover as many as topics of Set Analysis with ample number of video examples, starting from basic to varying level of complexity, Anyone who join and finish this video training, will able to write most complex and scary expressions with ease.
This course covers more than 50 videos with 100+ examples.
There are 50+ questions given as quiz/assignments.
Who Should Attend!
- QlikView/QlikSense Designers and Developers (basic to advanced level)
- Business Analysts
- BI Developers
