Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Customer flow analysis

I  have a monthly data of the following structure:

MonthNameDrinkAge
janACoffee22
janBTea24
janCCoffee21
jan DCoffee25
janECoke20
febACoffee22
febBTea24
febCTea21
febDTea25
febETea20

 

I need to create the below matrix where i can see the flow of customers from one drink to another over Month. Eg. 2 customers drinking coffee in Jan prefer Tea in Feb.

The actual problem will need to accommodate comparison of different months and items( like drinks here). 

Jan\FebCoffee TeaCoke
Coffee120
Tea010
Coke010
Labels (4)
4 Replies
Highlighted
MVP
MVP

@stoic_presi  how much years worth of data do you have?  

Highlighted
Contributor II
Contributor II

3 years of data.  But from analysis perspective  change in 1 month, 3 month, 6 month and 1 year is desirable. and volume wise > monthly snapshot is ~ 1000000 rows.

Highlighted
MVP
MVP

@stoic_presi  How the comparison is needed? Is it always selected month month with previous month or any two month selections?

Highlighted
Contributor II
Contributor II

Hi Kush, Like mentioned in the reply change in 1 month, 3 month, 6 month and 1 year is desirable if not fully dynamic. Like curr. month vs last month or curr. month vs 3 months ago. etc.           The main script cannot be changed as its a 100+ column data and the requested problem is one of many use cases.