Hi, I am trying to come up with a cohort retention analysis in Qlik of this sort to see how customers are retained over time
Month
New Customers
Month 1
Month 2
Month 3
Jan 2023
100
100
85
50
Feb 2023
1000
1085*
900
Mar 2023
500
1400*
*This displays total customers, that is New customers in Month 2 + returning customers from Month 1 (e.g. 1000 + 85 and 900 + 500)
The only way I managed to do is come up with a pivot table to show the retained customers but I cannot find a way to add the new customers. How can I do this to achieve the above cohort chart?
