The third sheet: Customer details
In this tutorial, you’ll create the third sheet of your Qlik Cloud app — focusing on customer analysis using scatter plots, pivot tables, and filters.
You’ll learn how to:
Build a scatter plot to compare sales and quantity by customer
Create a pivot table to analyze KPIs and add custom measures
Add filter panes to explore data by time and manager
By the end, you’ll have a detailed and interactive view of customer performance — ready to integrate into your Qlik Cloud dashboard.
🎬 00:11 – Introduction: Creating the Third Sheet
📈 00:16 – Scatter Plot: Customer Sales vs Quantity
⚙️ 00:54 – Creating and Adding Master Measures
🧭 01:19 – Customizing Axes and Titles
📊 01:37 – Pivot Table: Customer KPI Overview
➕ 02:26 – Adding Margin %, Invoice Count, and Avg. Sales
💲 03:54 – Formatting Sales and Quantity Measures
🏷️ 04:10 – Adding Product Group and Type Dimensions
🎚️ 04:26 – Adding Filter Panes for Time and Manager
✅ 04:50 – Third Sheet Complete