Home

All courses

Mastering QlikView Set Analysis

Qlikview

Business Analytics & Intelligence

Business

Mastering QlikView Set Analysis

Deep Dive Set Analysis Course for QlikView and Qlik Sense Developers

4.6

(792)

3864 enrolled on this course

Last updated 11/2021

None

₹ 1999.0

₹ 3499.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

Are you afraid of using one of the most power QlikView or Qlik Sense functionalities, Set Analysis, to build powerful QlikView or Qlik Sense applications because its syntax is daunting? You are not alone!

This course will teach you step-by-step to master Set Analysis so that you can start writing advanced aggregation expressions in QlikView and Qlik Sense with ease!

You will learn basics of Set Analysis first and then dive into advanced Set Analysis concepts to leverage this powerful advanced aggregation functionality in your QlikView or Qlik Sense application.
Who this course is for:
QlikView developers
Business Analysts
QlikView designers

What you'll learn

Master Set Analysis syntax and write Set Analysis expressions with confidence

Set Modifier Deep Dive

Learn how to use Set Identifiers, Modifiers and Operators in Set Analysis Expression

Learn how to use Dollar-sign, Double Dollar-Sign expansion, expressions within Set Modifier

Learn how to use Alternate States with Set Analysis

Learn Useful functions with Set Analysis advanced aggregations

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-Getting Started

1.1-1.1: Course Introduction

1.2-1.2: Setup - Loading QVD Files

1.3-1.3: Associative Model

2-Set Analysis Fundementals

2.1-2.1: What is Set Analysis and Why use it?

2.2-2.2: Visual Representation of Set Analysis

2.3-2.3: Set Theory Refresher

2.4-2.4: Conceptual Aside - Set Identifier

2.5-Set Identifier

2.6-2.5: Conceptual Aside - Set Operator

2.7-Set Operator

2.8-2.6 - Challenge - Set Identifier (Introduction)

2.9-2.6: Challenge - Set Identifier

2.10-2.7: Solution - Set Identifier

2.11-2.8: Challenge - Set Operator

2.12-2.9: Solution - Set Operator

3-Set Modifier Deep Dive

3.1-3.1: Conceptual Aside - Set Modifier

3.2-3.2: Challenge - Set Modifier

3.3-3.3: Solution - Set Modifier

3.4-Set Modifier

3.5-3.4: Conceptual Aside - Two or More Set Modifiers

3.6-3.5: Challenge - Two or More Set Modifiers

3.7-3.6: Solution - Two or More Set Modifiers Part I

3.8-3.6: Solution - Two or More Set Modifiers Part II

3.9-Two or More Set Modifiers

3.10-3.7: Challenge - Set Modifiers with Wild Card

3.11-3.8: Solution - Set Modifiers with Wild Card

3.12-3.9: Conceptual Aside - Set Modifiers with Range

3.13-3.10: Challenge - Set Modifiers with Range

3.14-3.11: Solution - Set Modifiers with Range

3.15-Set Modifier with Range

3.16-3.12: Conceptual Aside - Nested Expressions

3.17-3.13: Challenge - Nested Expressions

3.18-3.14: Solution - Nested Expressions

3.19-Lesson 3.14: Challenge 11 Revised solution

3.20-Nested Expessions

3.21-3.15: Challenge - Advanced Set Modifier

3.22-3.16: Solution - Advanced Set Modifier

3.23-3.17: Conceptual Aside - Element Functions P() and E()

3.24-3.18: Challenge - Element Functions P() and E()

3.25-3.19: Solution - Element Functions P() and E()

3.26-Element Functions - P() and E()

4-Advanced Set Analysis

4.1-4.1: Conceptual Aside - Dollar Sign Expansion

4.2-Dollar Sign Expansion

4.3-4.2: Conceptual Aside - Double Dollar Sign Expansion

4.4-4.3: Conceptual Aside - Parameterized Dollar Sign Expansion

4.5-Parameterized Dollar Sign Expansion

4.6-4.4: Conceptual Aside - Set Exclusions

4.7-Set Exclusion

4.8-4.5: Conceptual Aside - Dealing with NULL values

4.9-Dealing with NULL values

4.10-4.6: Conceptual Aside - Set Analysis with Alternate States

4.11-Set Analysis with Alternate States

4.12-4.7: Conceptual Aside - Compare two fields

4.13-4.8: Conceptual Aside - Interesting operators

4.14-Interesting Operators

4.15-4.9: Conceptual Aside - Set Modifier with an Expression

4.16-Set Modifier with an Expression

4.17-Lesson 4.10: Challenge - Set Analysis with Alternate States

4.18-Lesson 4.11: Solution - Set Analysis with Alternate States

4.19-Lesson 4.12: Challenge - Exclusion operators

4.20-Lesson 4.13: Solution - Exclusion operators

4.21-Lesson 4.14: Challenge - Compare two fields

4.22-Lesson 4.15: Solution - Compare two fields

5-Useful Set Functions

5.1-5.1: Conceptual Aside - Aggr()

5.2-Aggr() Function

5.3-5.2: Challenge I - Aggr()

5.4-5.2: Challenge II - Aggr()

5.5-5.2: Challenge III - Aggr()

5.6-5.3: Solution I - Aggr()

5.7-5.3: Solution II - Aggr()

5.8-5.3: Solution III - Aggr()

5.9-5.4: Conceptual Aside - Concat()

5.10-Concat() Function

5.11-5.5: Challenge - Concat()

5.12-5.6: Solution - Concat()

5.13-5.7: Conceptual Aside: FirstSortedValue()

5.14-5.8: Challenge 1 - FirstSortedValue()

5.15-5.8: Solution 1 - FirstSortedValue()

5.16-5.9: Challenge 2 - FirstSortedValue()

5.17-5.9: Solution 2 - FirstSortedValue()

5.18-Summary

6-Bonus

6.1-Mastering QlikView Set Analysis Guide: Syntax and Examples

Course Categories

Popular Courses

Mastering QlikView Set Analysis

Description

What you'll learn

Requirements

Course Content

You May Like