Your QlikView Journey Begins Here
  • Course Introduction
  • Download And Install QlikView Personal Edition Software
  • Download And Install SQL Server Express
  • How To Get Your Project Data From Dropbox
  • Quick Tips And Links
  • Navigating The QlikView Desktop
  • Create Document Content Using Wizards
  • Mission Assignment #1 If You Choose To Accept It
  • Test Yourself
Data Modelling In QlikView
  • Introduction to the Associative Model
  • The Star Schema
  • The Snowflake Schema
  • Mission Assignment #2 If You Choose To Accept It
  • The Synthetic Key And Your Model
  • Circular Reference (Loops) Break Your Model
  • Link Table(s) In Your Model - Part 1
  • Link Tables(s) In Your Model - Part 2
  • Mission Assignment #3 If You Choose To Accept It
  • Test Yourself
Coding Joins In The Script
  • The Inner Join
  • The Left Join
  • The Right Join
  • The Outer Join
  • Mission Assignment #4 If You Choose To Accept It
  • Mission #4 Solution Explanation
  • Test Yourself
Scripting The ETL (Extract, Transform, Load)
  • What IS ETL Exactly ?
  • ETL-1 SQL And The Inline Load (Part 1)
  • ETL-1 SQL And The Inline Load (Part 2)
  • ETL-1 SQL And The Inline Load (Part 3)
  • ETL-1 SQL And The Inline Load (Part 4)
  • ETL-2 Loading From Disparate Data Sources (Part 1)
  • ETL-2 Loading From Disparate Data Sources (Part 2)
  • ETL-3 The Incremental Load (Part 1)
  • ETL-3 The Incremental Load (Part 2)
  • ETL-4 The Slowly Changing Dimension (SCD)
  • Mission Assignment #5 If You Choose To Accept It
  • Mission #5 Solution Explanation
  • Test Yourself
Develop Your First Dashboard
  • Getting Started
  • Basic Aggregations Overview
  • Adding Filters & Current Selections Object
  • The Combo Chart & Calculated Dimensions
  • The Combo Chart & Object Cloning
  • Dimension Limiting & Aggregation Scope
  • Coding Conditional Colours
  • The Pivot Table
  • Mission #6 If You Choose To Accept It
  • Mission #6 Solution Explanation
  • Test Yourself
Preparation For Your Enterprise Solution Development
  • Visualisation Best Practices
  • Initial Data Model Load Incl. Mapping Load
  • Initial Data Model Load Incl. Concatenated Load
  • Initial Data Model Load Incl. Reduced Data Load
  • Test Yourself
The KPI
  • A Conversation Around Metrics & KPI's
  • Coding A Simple KPI
  • Coding a KPI With A Calculation
  • Mission Assignment #7 If You Choose To Accept It
  • Mission #7 Solution Explanation
  • Test Yourself
Explore And Develop Charts
  • The Straight Table And The Mini Chart
  • The Straight Table With Drill Down & Cyclic Groups
  • The Line Chart With Dual Axes
  • The Bar Chart & Classed Data
  • The Bar Chart Becomes A Combo Chart
  • The Gauge Chart
  • The Butterfly Chart (aka Tornado Chart) Part 1
  • The Butterfly Chart (aka Tornado Chart) Part 2
  • The Scatter Chart
  • Mission Assignment #8 If You Choose To Accept It
  • Mission #8 Solution Explanation
  • Test Yourself
Implement An SCD Type 2 In Our Solution
  • The IntervalMatch() Function
  • Exploiting The Container Object
  • Mission Assignment #9 If You Choose To Accept It
  • Mission #9 Solution Explanation
  • A Quick Quiz
Understand And Code Set Analysis
  • What Is Set Analysis ?
  • Coding KPI's (Part 1)
  • Coding KPI's (Part 2)
  • Dates, Set Analysis and Charting
  • Date Spans In Set Analysis e.g. MTD with MonthStart()
  • Date Spans In Set Analysis & The Dual() Function
  • Embedding Multiple Functions Inside Set Analysis
  • Mission Assignment #10 If You Choose To Accept It
  • Mission #10 Solution Explanation
  • Test Yourself
The Magic Of Variables
  • Getting Started With Variables