QlikSense Class 8 - Analyse Profit and Loss | Paul Scotchford | Skillshare

QlikSense Class 8 - Analyse Profit and Loss

Paul Scotchford, Business Intelligence and Analytics developer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
7 Lessons (1h 37m)
    • 1. Lecture 52 Introducing another example of a Compound Key with our data

    • 2. Lecture 53 What is a variable and how is it used in QlikSense

    • 3. Lecture 54 Using variables to store date functions

    • 4. Lecture 55 Using variables in Set Analysis

    • 5. Lecture 56 Use variables in the data visualization instead

    • 6. Lecture 57 Embed formatting expressions in Variables

    • 7. Lecture 58 How to handle delimited strings that need to be in a variable


About This Class

I recommend that you complete QlikSense Class 7 - Analyze Payroll data before taking this class.

Our start-up has needs to produce a P & L Statement

These lectures will teach you how to build a P&L App and as we build the app you will also learn how to ...

  1. Explore more about composite keys
  2. Create and use variables
  3. Compute dates
  4. Use variables in Set Analysis
  5. Understand $ Expansion
  6. Multi Line expressions in the Load Script
  7. Embed delimited strings into variables






  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv


Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Paul Scotchford

Business Intelligence and Analytics developer

I have over 12 years experience as a Business Intelligence and Analytics developer specialising in both the Microsoft and Qlik technology environment.

Since 2012 I have been developing QlikView and in late 2014 I discovered QlikSense, my QlikView skills were immediately transferable to QlikSense too.

I have also been developing with SQL since the late 90's and have extensive experience in data extraction, modelling and analytics directly from ERP and Data Warehouse structures.

See full profile

Report class