Mastering QlikView Set Analysis

Course Curriculum

Chapter 1: Getting Started

Lecture 1: 1.1: Course Introduction

Lecture 2: 1.2: Setup – Loading QVD Files

Lecture 3: 1.3: Associative Model

Chapter 2: Set Analysis Fundementals

Lecture 1: 2.1: What is Set Analysis and Why use it?

Lecture 2: 2.2: Visual Representation of Set Analysis

Lecture 3: 2.3: Set Theory Refresher

Lecture 4: 2.4: Conceptual Aside – Set Identifier

Lecture 5: 2.5: Conceptual Aside – Set Operator

Lecture 6: 2.6 – Challenge – Set Identifier (Introduction)

Lecture 7: 2.6: Challenge – Set Identifier

Lecture 8: 2.7: Solution – Set Identifier

Lecture 9: 2.8: Challenge – Set Operator

Lecture 10: 2.9: Solution – Set Operator

Chapter 3: Set Modifier Deep Dive

Lecture 1: 3.1: Conceptual Aside – Set Modifier

Lecture 2: 3.2: Challenge – Set Modifier

Lecture 3: 3.3: Solution – Set Modifier

Lecture 4: 3.4: Conceptual Aside – Two or More Set Modifiers

Lecture 5: 3.5: Challenge – Two or More Set Modifiers

Lecture 6: 3.6: Solution – Two or More Set Modifiers Part I

Lecture 7: 3.6: Solution – Two or More Set Modifiers Part II

Lecture 8: 3.7: Challenge – Set Modifiers with Wild Card

Lecture 9: 3.8: Solution – Set Modifiers with Wild Card

Lecture 10: 3.9: Conceptual Aside – Set Modifiers with Range

Lecture 11: 3.10: Challenge – Set Modifiers with Range

Lecture 12: 3.11: Solution – Set Modifiers with Range

Lecture 13: 3.12: Conceptual Aside – Nested Expressions

Lecture 14: 3.13: Challenge – Nested Expressions

Lecture 15: 3.14: Solution – Nested Expressions

Lecture 16: Lesson 3.14: Challenge 11 Revised solution

Lecture 17: 3.15: Challenge – Advanced Set Modifier

Lecture 18: 3.16: Solution – Advanced Set Modifier

Lecture 19: 3.17: Conceptual Aside – Element Functions P() and E()

Lecture 20: 3.18: Challenge – Element Functions P() and E()

Lecture 21: 3.19: Solution – Element Functions P() and E()

Chapter 4: Advanced Set Analysis

Lecture 1: 4.1: Conceptual Aside – Dollar Sign Expansion

Lecture 2: 4.2: Conceptual Aside – Double Dollar Sign Expansion

Lecture 3: 4.3: Conceptual Aside – Parameterized Dollar Sign Expansion

Lecture 4: 4.4: Conceptual Aside – Set Exclusions

Lecture 5: 4.5: Conceptual Aside – Dealing with NULL values

Lecture 6: 4.6: Conceptual Aside – Set Analysis with Alternate States

Lecture 7: 4.7: Conceptual Aside – Compare two fields

Lecture 8: 4.8: Conceptual Aside – Interesting operators

Lecture 9: 4.9: Conceptual Aside – Set Modifier with an Expression

Lecture 10: Lesson 4.10: Challenge – Set Analysis with Alternate States

Lecture 11: Lesson 4.11: Solution – Set Analysis with Alternate States

Lecture 12: Lesson 4.12: Challenge – Exclusion operators

Lecture 13: Lesson 4.13: Solution – Exclusion operators

Lecture 14: Lesson 4.14: Challenge – Compare two fields

Lecture 15: Lesson 4.15: Solution – Compare two fields

Chapter 5: Useful Set Functions

Lecture 1: 5.1: Conceptual Aside – Aggr()

Lecture 2: 5.2: Challenge I – Aggr()

Lecture 3: 5.2: Challenge II – Aggr()

Lecture 4: 5.2: Challenge III – Aggr()

Lecture 5: 5.3: Solution I – Aggr()

Lecture 6: 5.3: Solution II – Aggr()

Lecture 7: 5.3: Solution III – Aggr()

Lecture 8: 5.4: Conceptual Aside – Concat()

Lecture 9: 5.5: Challenge – Concat()

Lecture 10: 5.6: Solution – Concat()

Lecture 11: 5.7: Conceptual Aside: FirstSortedValue()

Lecture 12: 5.8: Challenge 1 – FirstSortedValue()

Lecture 13: 5.8: Solution 1 – FirstSortedValue()

Lecture 14: 5.9: Challenge 2 – FirstSortedValue()

Lecture 15: 5.9: Solution 2 – FirstSortedValue()

Lecture 16: Summary

Chapter 6: Bonus

Lecture 1: Mastering QlikView Set Analysis Guide: Syntax and Examples