#44 👨‍💼 Customer habit analysis in Qlik Sense

💪 Empower your sales app and customer habits analysis 🤪 and playing with the Peek() function


Here starts a post series because I realized I've too much to say on this topic, so let's start at the beginning

My dataset is basically composed by Orders and Customers :

What are they purchasing first ? For how much money and products ? Are they buying more or less over the time ? Do they purchase a lot at once or frequently ?

There is too much to learn about customer life !


In this simple dashboard, you can select the first purchase on any customer or then see his accumulated order amount...

Without any Set Analysis ! 🎁

How ? You just have to properly create the data in the load script using Peek() 🧙‍♂️

When you learn Qlik, we teach you that you must use a field from the datasource or the resident table inside the LOAD statement, right ?

Wrong 😜

Download QVF
Sheet First order analysis

read more Business Analysis

⁉ How To ⁉

You can actually create a field and refer to it on the same line
1-Test if the previous line contain the different value for Customer
2 - Put 1 or increment this new field with the previous record
if("Customer Name"<> Peek("Customer Name"),
1,Peek(OrderNo)+1) as OrderNo,
same logic:
if(... ,
OrderAmount,OrderAmount+Peek(AccumulatedOrderAmount)) as AccumulatedOrderAmount