Home

All courses

Become an expert of Qlik Set Analysis

IT & Software

Other IT & Software

Qlikview

Become an expert of Qlik Set Analysis

Qlik - Set Analysis

4.4

(319)

1442 enrolled on this course

Last updated 11/2021

None

₹ 3299.0

₹ 4799.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

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 this course is for:
QlikView/QlikSense Designers and Developers (basic to advanced level)
Business Analysts
BI Developers

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?

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-01 Introduction

1.1-01 Introduction

2-02 Before You Start!

2.1-02 Before You Start!

3-03 Introduction of Data Tables and Qlik Script

3.1-3.1 Introduction of Data Tables

3.2-3.2 QVD Viewer, Script and Data Model

4-04 Introduction to Set Analysis

4.1-4.1 What is Set Analysis

4.2-4.2 Understand Set Analysis Practically

5-05 Set Analysis Syntax and Components

5.1-5.1 Set Analysis and it's Components

6-06 Set Identifiers and Set Operators

6.1-6.1 Introduction of QVW

6.2-6.2 Set Identifiers Part 01

6.3-6.3 Set Identifiers Part 02

6.4-Quiz 01

6.5-6.4 Set Identifiers Part 03

6.6-6.5 Set Identifier Part 04

6.7-6.6 Set Operators

6.8-Quiz 02

7-07 Set Modifiers

7.1-7.1 String and Integer Part 01

7.2-7.2 String and Integer Part 02

7.3-7.3 BookMarks

7.4-Quiz 03

7.5-7.4 Wildcard searches

7.6-7.5 Functions returning Members

7.7-7.6 Nested Set Analysis

7.8-Quiz 04

7.9-7.7 Handling Null Values

7.10-7.8 Compare Two Fields

7.11-7.9 Set Operators inside Set Modifiers

8-08 Forced Exclusion of Fields

8.1-8.1 Exclude Fields in Set Expression

8.2-8.2 Using a Function for Multiple Field Exclusion

8.3-8.3 Using $ with Field Exclusion

8.4-Quiz 05

9-09 Dollar-sign Expansion

9.1-9.1 Dollar-sign Expansion

9.2-9.2 Formatting Dollar-sign Result Part 01

9.3-9.3 Formatting Dollar-sign Result Part 02

9.4-Quiz 06

10-10 Point in Time Reporting

10.1-10.1 Type of requirements & Important Date Functions

10.2-10.2 YTD and MTD Reports

10.3-10.3 Point in Time Reporting with Nested Set Expression

10.4-10.4 Growth report by comparing periods

11-11 Comparative Analysis using Alternate State and Set Analysis

11.1-11.1 Alternate State Introduction

11.2-11.2 Alternate State with Default State

11.3-Quiz 07

12-12 Using Variables in Set Analysis

12.1-12.1 Introduction and Examples

12.2-12.2 Using Variables for Point in Time Reporting

12.3-12.3 Double Dollar Sign Expansion

12.4-12.4 Variables with Parameters

12.5-Quiz 08

13-13 Indirect Set Analysis

13.1-13.1 Introduction of P() and E()

13.2-13.2 Examples of P and E() Part 1

13.3-13.3 Examples of P() and E() Part 2

13.4-Quiz 09

14-14 Set Analysis inside useful QV Functions

14.1-14.1 Functions Introduction

14.2-14.2 Useful QV Functions Part 01

14.3-14.3 Useful QV Functions Part 02

14.4-14.4 Useful QV Functions Part 03

14.5-14.5 Useful QV Functions Part 04

14.6-14.6 Useful QV Functions Part 05

14.7-14.7 Useful QV Functions Part 06

14.8-Quiz 10

15-15 Bonus Videos

15.1-15.1 Set Analysis Demo in Qlik Sense

15.2-15.2 Creating Flags for Bookmarks

15.3-15.3 Creating Flags for Calendar Fields

Course Categories

Popular Courses

Become an expert of Qlik Set Analysis

Description

What you'll learn

Requirements

Course Content

You May Like