Become an expert of Qlik Set Analysis

Course Curriculum

Chapter 1: 01 Introduction

Lecture 1: 01 Introduction

Chapter 2: 02 Before You Start!

Lecture 1: 02 Before You Start!

Chapter 3: 03 Introduction of Data Tables and Qlik Script

Lecture 1: 3.1 Introduction of Data Tables

Lecture 2: 3.2 QVD Viewer, Script and Data Model

Chapter 4: 04 Introduction to Set Analysis

Lecture 1: 4.1 What is Set Analysis

Lecture 2: 4.2 Understand Set Analysis Practically

Chapter 5: 05 Set Analysis Syntax and Components

Lecture 1: 5.1 Set Analysis and it's Components

Chapter 6: 06 Set Identifiers and Set Operators

Lecture 1: 6.1 Introduction of QVW

Lecture 2: 6.2 Set Identifiers Part 01

Lecture 3: 6.3 Set Identifiers Part 02

Lecture 4: 6.4 Set Identifiers Part 03

Lecture 5: 6.5 Set Identifier Part 04

Lecture 6: 6.6 Set Operators

Chapter 7: 07 Set Modifiers

Lecture 1: 7.1 String and Integer Part 01

Lecture 2: 7.2 String and Integer Part 02

Lecture 3: 7.3 BookMarks

Lecture 4: 7.4 Wildcard searches

Lecture 5: 7.5 Functions returning Members

Lecture 6: 7.6 Nested Set Analysis

Lecture 7: 7.7 Handling Null Values

Lecture 8: 7.8 Compare Two Fields

Lecture 9: 7.9 Set Operators inside Set Modifiers

Chapter 8: 08 Forced Exclusion of Fields

Lecture 1: 8.1 Exclude Fields in Set Expression

Lecture 2: 8.2 Using a Function for Multiple Field Exclusion

Lecture 3: 8.3 Using $ with Field Exclusion

Chapter 9: 09 Dollar-sign Expansion

Lecture 1: 9.1 Dollar-sign Expansion

Lecture 2: 9.2 Formatting Dollar-sign Result Part 01

Lecture 3: 9.3 Formatting Dollar-sign Result Part 02

Chapter 10: 10 Point in Time Reporting

Lecture 1: 10.1 Type of requirements & Important Date Functions

Lecture 2: 10.2 YTD and MTD Reports

Lecture 3: 10.3 Point in Time Reporting with Nested Set Expression

Lecture 4: 10.4 Growth report by comparing periods

Chapter 11: 11 Comparative Analysis using Alternate State and Set Analysis

Lecture 1: 11.1 Alternate State Introduction

Lecture 2: 11.2 Alternate State with Default State

Chapter 12: 12 Using Variables in Set Analysis

Lecture 1: 12.1 Introduction and Examples

Lecture 2: 12.2 Using Variables for Point in Time Reporting

Lecture 3: 12.3 Double Dollar Sign Expansion

Lecture 4: 12.4 Variables with Parameters

Chapter 13: 13 Indirect Set Analysis

Lecture 1: 13.1 Introduction of P() and E()

Lecture 2: 13.2 Examples of P and E() Part 1

Lecture 3: 13.3 Examples of P() and E() Part 2

Chapter 14: 14 Set Analysis inside useful QV Functions

Lecture 1: 14.1 Functions Introduction

Lecture 2: 14.2 Useful QV Functions Part 01

Lecture 3: 14.3 Useful QV Functions Part 02

Lecture 4: 14.4 Useful QV Functions Part 03

Lecture 5: 14.5 Useful QV Functions Part 04

Lecture 6: 14.6 Useful QV Functions Part 05

Lecture 7: 14.7 Useful QV Functions Part 06

Chapter 15: 15 Bonus Videos

Lecture 1: 15.1 Set Analysis Demo in Qlik Sense

Lecture 2: 15.2 Creating Flags for Bookmarks

Lecture 3: 15.3 Creating Flags for Calendar Fields