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?
