Getting Started
  • 1.1: Course Introduction
  • 1.2: Setup - Loading QVD Files
  • 1.3: Associative Model
Set Analysis Fundementals
  • 2.1: What is Set Analysis and Why use it?
  • 2.2: Visual Representation of Set Analysis
  • 2.3: Set Theory Refresher
  • 2.4: Conceptual Aside - Set Identifier
  • Set Identifier
  • 2.5: Conceptual Aside - Set Operator
  • Set Operator
  • 2.6 - Challenge - Set Identifier (Introduction)
  • 2.6: Challenge - Set Identifier
  • 2.7: Solution - Set Identifier
  • 2.8: Challenge - Set Operator
  • 2.9: Solution - Set Operator
Set Modifier Deep Dive
  • 3.1: Conceptual Aside - Set Modifier
  • 3.2: Challenge - Set Modifier
  • 3.3: Solution - Set Modifier
  • Set Modifier
  • 3.4: Conceptual Aside - Two or More Set Modifiers
  • 3.5: Challenge - Two or More Set Modifiers
  • 3.6: Solution - Two or More Set Modifiers Part I
  • 3.6: Solution - Two or More Set Modifiers Part II
  • Two or More Set Modifiers
  • 3.7: Challenge - Set Modifiers with Wild Card
  • 3.8: Solution - Set Modifiers with Wild Card
  • 3.9: Conceptual Aside - Set Modifiers with Range
  • 3.10: Challenge - Set Modifiers with Range
  • 3.11: Solution - Set Modifiers with Range
  • Set Modifier with Range
  • 3.12: Conceptual Aside - Nested Expressions
  • 3.13: Challenge - Nested Expressions
  • 3.14: Solution - Nested Expressions
  • Lesson 3.14: Challenge 11 Revised solution
  • Nested Expessions
  • 3.15: Challenge - Advanced Set Modifier
  • 3.16: Solution - Advanced Set Modifier
  • 3.17: Conceptual Aside - Element Functions P() and E()
  • 3.18: Challenge - Element Functions P() and E()
  • 3.19: Solution - Element Functions P() and E()
  • Element Functions - P() and E()
Advanced Set Analysis
  • 4.1: Conceptual Aside - Dollar Sign Expansion
  • Dollar Sign Expansion
  • 4.2: Conceptual Aside - Double Dollar Sign Expansion
  • 4.3: Conceptual Aside - Parameterized Dollar Sign Expansion
  • Parameterized Dollar Sign Expansion
  • 4.4: Conceptual Aside - Set Exclusions
  • Set Exclusion
  • 4.5: Conceptual Aside - Dealing with NULL values
  • Dealing with NULL values
  • 4.6: Conceptual Aside - Set Analysis with Alternate States
  • Set Analysis with Alternate States
  • 4.7: Conceptual Aside - Compare two fields
  • 4.8: Conceptual Aside - Interesting operators
  • Interesting Operators
  • 4.9: Conceptual Aside - Set Modifier with an Expression
  • Set Modifier with an Expression
  • Lesson 4.10: Challenge - Set Analysis with Alternate States
  • Lesson 4.11: Solution - Set Analysis with Alternate States
  • Lesson 4.12: Challenge - Exclusion operators
  • Lesson 4.13: Solution - Exclusion operators
  • Lesson 4.14: Challenge - Compare two fields
  • Lesson 4.15: Solution - Compare two fields
Useful Set Functions
  • 5.1: Conceptual Aside - Aggr()
  • Aggr() Function
  • 5.2: Challenge I - Aggr()
  • 5.2: Challenge II - Aggr()
  • 5.2: Challenge III - Aggr()
  • 5.3: Solution I - Aggr()
  • 5.3: Solution II - Aggr()
  • 5.3: Solution III - Aggr()
  • 5.4: Conceptual Aside - Concat()
  • Concat() Function
  • 5.5: Challenge - Concat()
  • 5.6: Solution - Concat()
  • 5.7: Conceptual Aside: FirstSortedValue()
  • 5.8: Challenge 1 - FirstSortedValue()
  • 5.8: Solution 1 - FirstSortedValue()
  • 5.9: Challenge 2 - FirstSortedValue()
  • 5.9: Solution 2 - FirstSortedValue()
  • Summary
Bonus
  • Mastering QlikView Set Analysis Guide: Syntax and Examples