Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
8 Hour(s) 0 Minute(s)
Language
English
Taught by
Manish Kachhia
Rating
2 views
Course Overview
Qlik - Set Analysis
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.
Course Content
- 15 section(s)
- 51 lecture(s)
- Section 1 01 Introduction
- Section 2 02 Before You Start!
- Section 3 03 Introduction of Data Tables and Qlik Script
- Section 4 04 Introduction to Set Analysis
- Section 5 05 Set Analysis Syntax and Components
- Section 6 06 Set Identifiers and Set Operators
- Section 7 07 Set Modifiers
- Section 8 08 Forced Exclusion of Fields
- Section 9 09 Dollar-sign Expansion
- Section 10 10 Point in Time Reporting
- Section 11 11 Comparative Analysis using Alternate State and Set Analysis
- Section 12 12 Using Variables in Set Analysis
- Section 13 13 Indirect Set Analysis
- Section 14 14 Set Analysis inside useful QV Functions
- Section 15 15 Bonus Videos
What You’ll 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?
Skills covered in this course
Reviews
-
SSarah WU
As a Qlik Beginner, this course deserves more than 5 stars. I learned a lot from these videos which give me clearer structures on set expression. Thanks so much Manish.
-
VVsevolod Kadykov
Понятный английский , понятные обьяснения. Немного не в порядке данные,надо немного их изменить для выполнения заданий . Теперь гораздо продвинутей понимаю сет анализ.
-
GGlen VanDerHart
Great information. Just had difficulty with his accent. But well worth it.
-
JJohan Kassing
I am very happy that I took this course about set analysis. The man who gives this course explains everything very well and the further I come into the sections I am getting more and more impressed. I looked on Udemy if he gives more courses but unfortunately not because I would have bought those to. To the teacher: thank you very much and I hope you will take up some interesting concepts of Qlik Sense and View into new courses.
