Mastering QlikView Set Analysis
4.2 (427 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,209 students enrolled

Mastering QlikView Set Analysis

Deep Dive Set Analysis Course for QlikView and Qlik Sense Developers
4.2 (427 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,209 students enrolled
Last updated 1/2017
English
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5.5 hours on-demand video
  • 17 articles
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
  • QlikView development
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
Course content
Expand all 66 lectures 05:37:35
+ Getting Started
3 lectures 13:30
1.2: Setup - Loading QVD Files
03:54
1.3: Associative Model
06:42
+ Set Analysis Fundementals
10 lectures 01:08:56
2.2: Visual Representation of Set Analysis
08:24
2.3: Set Theory Refresher
05:20
2.4: Conceptual Aside - Set Identifier
12:49
Set Identifier
3 questions
2.5: Conceptual Aside - Set Operator
09:13
Set Operator
2 questions
2.6 - Challenge - Set Identifier (Introduction)
01:07
2.6: Challenge - Set Identifier
00:17
2.7: Solution - Set Identifier
08:20
2.8: Challenge - Set Operator
00:21
2.9: Solution - Set Operator
15:11
+ Set Modifier Deep Dive
21 lectures 01:51:43
3.1: Conceptual Aside - Set Modifier
12:32
3.2: Challenge - Set Modifier
00:43
3.3: Solution - Set Modifier
08:44
Set Modifier
2 questions
3.4: Conceptual Aside - Two or More Set Modifiers
03:13
3.5: Challenge - Two or More Set Modifiers
00:10
3.6: Solution - Two or More Set Modifiers Part I
04:04
3.6: Solution - Two or More Set Modifiers Part II
08:15
Two or More Set Modifiers
2 questions
3.7: Challenge - Set Modifiers with Wild Card
00:16
3.8: Solution - Set Modifiers with Wild Card
05:53
3.9: Conceptual Aside - Set Modifiers with Range
04:01
3.10: Challenge - Set Modifiers with Range
00:27
3.11: Solution - Set Modifiers with Range
13:11
Set Modifier with Range
2 questions
3.12: Conceptual Aside - Nested Expressions
07:51
3.13: Challenge - Nested Expressions
00:24
3.14: Solution - Nested Expressions
11:15
Lesson 3.14: Challenge 11 Revised solution
05:21
Nested Expessions
2 questions
3.15: Challenge - Advanced Set Modifier
00:29
3.16: Solution - Advanced Set Modifier
11:15
3.17: Conceptual Aside - Element Functions P() and E()
05:03
3.18: Challenge - Element Functions P() and E()
00:17
3.19: Solution - Element Functions P() and E()
08:17
Element Functions - P() and E()
2 questions
+ Advanced Set Analysis
15 lectures 01:06:05
4.1: Conceptual Aside - Dollar Sign Expansion
07:24
Dollar Sign Expansion
2 questions
4.2: Conceptual Aside - Double Dollar Sign Expansion
04:42
4.3: Conceptual Aside - Parameterized Dollar Sign Expansion
04:08
Parameterized Dollar Sign Expansion
2 questions
4.4: Conceptual Aside - Set Exclusions
06:43
Set Exclusion
2 questions
4.5: Conceptual Aside - Dealing with NULL values
07:12
Dealing with NULL values
2 questions
4.6: Conceptual Aside - Set Analysis with Alternate States
06:20
Set Analysis with Alternate States
2 questions
4.7: Conceptual Aside - Compare two fields
04:36
4.8: Conceptual Aside - Interesting operators
08:10
Interesting Operators
2 questions
4.9: Conceptual Aside - Set Modifier with an Expression
04:37
Set Modifier with an Expression
2 questions
Lesson 4.10: Challenge - Set Analysis with Alternate States
01:04
Lesson 4.11: Solution - Set Analysis with Alternate States
04:39

Challenge 4.12: Exclusion operator

Create a Line chart that shows sales for all product categories except Condiments, Confections, Grains and Cereals.

Even if user selects any of those categories, it should be excluded

Hint: Use -= operator. 

Lesson 4.12: Challenge - Exclusion operators
00:09
Lesson 4.13: Solution - Exclusion operators
03:04
Lesson 4.14: Challenge - Compare two fields
00:09
Lesson 4.15: Solution - Compare two fields
03:08
+ Useful Set Functions
16 lectures 01:17:16
5.1: Conceptual Aside - Aggr()
09:17
Aggr() Function
2 questions
5.2: Challenge I - Aggr()
00:10
5.2: Challenge II - Aggr()
00:10
5.2: Challenge III - Aggr()
00:08
5.3: Solution I - Aggr()
03:48
5.3: Solution II - Aggr()
08:37
5.3: Solution III - Aggr()
05:12
5.4: Conceptual Aside - Concat()
06:51
Concat() Function
3 questions
5.5: Challenge - Concat()
00:32
5.6: Solution - Concat()
06:54
5.7: Conceptual Aside: FirstSortedValue()
12:15
5.8: Challenge 1 - FirstSortedValue()
00:09
5.8: Solution 1 - FirstSortedValue()
11:00
5.9: Challenge 2 - FirstSortedValue()
00:12
5.9: Solution 2 - FirstSortedValue()
11:13
Summary
00:46
+ Bonus
1 lecture 00:03
Mastering QlikView Set Analysis Guide: Syntax and Examples
00:03