Become an expert of Qlik Set Analysis

Become an expert of Qlik Set Analysis, available at $89.99, has an average rating of 4.35, with 51 lectures, 10 quizzes, based on 298 reviews, and has 1391 subscribers.

You will learn about 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? This course is ideal for individuals who are QlikView/QlikSense Designers and Developers (basic to advanced level) or Business Analysts or BI Developers It is particularly useful for QlikView/QlikSense Designers and Developers (basic to advanced level) or Business Analysts or BI Developers.

Enroll now: Become an expert of Qlik Set Analysis

Summary

Title: Become an expert of Qlik Set Analysis

Price: $89.99

Average Rating: 4.35

Number of Lectures: 51

Number of Quizzes: 10

Number of Published Lectures: 51

Number of Published Quizzes: 10

Number of Curriculum Items: 61

Number of Published Curriculum Objects: 61

Original Price: $39.99

Quality Status: approved

Status: Live

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?

Who Should Attend

QlikView/QlikSense Designers and Developers (basic to advanced level)

Business Analysts

BI Developers

Target Audiences

QlikView/QlikSense Designers and Developers (basic to advanced level)

Business Analysts

BI Developers

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 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 its 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

Instructors

Manish Kachhia
BI Developer

Rating Distribution

1 stars: 8 votes

2 stars: 13 votes

3 stars: 35 votes

4 stars: 84 votes

5 stars: 158 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!