QV12BA Video Course

Curriculum For This Course

• 1. Before You Start! 1 Videos 00:01:00
  • Before You Start! 01:01
• 2. Introduction of Data Tables and Qlik Script 2 Videos 00:05:00
  • Introduction of Data Tables 03:08
  • QVD Viewer, Script and Data Model 02:28
• 3. Introduction to Set Analysis 2 Videos 00:15:00
  • What is Set Analysis 03:34
  • Understand Set Analysis Practically 11:06
• 4. Set Analysis Syntax and Components 1 Videos 00:05:00
  • Set Analysis and it's Components 04:45
• 5. Set Identifiers and Set Operators 6 Videos 00:36:00
  • Introduction of QVW 01:28
  • Set Identifiers Part 01 09:29
  • Set Identifiers Part 02 06:20
  • Set Identifiers Part 03 03:15
  • Set Identifier Part 04 02:46
  • Set Operators 13:55
• 6. Set Modifiers 9 Videos 01:23:00
  • String and Integer Part 01 10:21
  • String and Integer Part 02 14:19
  • BookMarks 08:03
  • Wildcard searches 08:13
  • Functions returning Members 15:21
  • Nested Set Analysis 07:16
  • Handling Null Values 07:25
  • Compare Two Fields 05:48
  • Set Operators inside Set Modifiers 08:23
• 7. Forced Exclusion of Fields 3 Videos 00:32:00
  • Exclude Fields in Set Expression 10:36
  • Using a Function for Multiple Field Exclusion 15:24
  • Using $ with Field Exclusion 05:46
• 8. Dollar-sign Expansion 3 Videos 00:33:00
  • Dollar-sign Expansion 13:18
  • Formatting Dollar-sign Result Part 01 12:39
  • Formatting Dollar-sign Result Part 02 07:21
• 9. Point in Time Reporting 4 Videos 01:01:00
  • Type of requirements & Important Date Functions 17:48
  • YTD and MTD Reports 16:30
  • Point in Time Reporting with Nested Set Expression 11:13
  • Growth report by comparing periods 14:56
• 10. Comparative Analysis using Alternate State and Set Analysis 2 Videos 00:27:00
  • Alternate State Introduction 13:14
  • Alternate State with Default State 13:44
• 11. Using Variables in Set Analysis 4 Videos 00:55:00
  • Introduction and Examples 15:43
  • Using Variables for Point in Time Reporting 15:48
  • Double Dollar Sign Expansion 10:46
  • Variables with Parameters 11:34
• 12. Indirect Set Analysis 3 Videos 00:41:00
  • Introduction of P() and E() 15:53
  • Examples of P and E() Part 1 10:18
  • Examples of P() and E() Part 2 14:58
• 13. Set Analysis inside useful QV Functions 7 Videos 00:47:00
  • Functions Introduction 09:25
  • Useful QV Functions Part 01 05:55
  • Useful QV Functions Part 02 06:50
  • Useful QV Functions Part 03 05:12
  • Useful QV Functions Part 04 06:34
  • Useful QV Functions Part 05 06:47
  • Useful QV Functions Part 06 05:32
• 14. Bonus Videos 3 Videos 00:34:00
  • Set Analysis Demo in Qlik Sense 22:42
  • Creating Flags for Bookmarks 05:37
  • Creating Flags for Calendar Fields 05:20