Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

prabunakil
New Contributor III

Calcalate Customer Retention Rate

Hi I need help. 

i have data like below:

Customer IDJoin YearPurchase Date
1201601.02.2017
2201701.02.2017
2201701.02.2018
2201702.02.2019
3201628.01.2016
3201615.01.2017

 

I want to calculate number of customer who no purchase more then five month.

Based on the table provide. The answer should be:

Customer ID: 1 and 3. 

How to calculate based on this.

Labels (1)
5 Replies
Highlighted
gn_marvs1989
New Contributor III

Re: Calcalate Customer Retention Rate

If you just wanted to show that in a chart or table, you can just use a set analysis on the expression:
count({<Purchase Date={"<$(=AddMonths(Today(),-5))"}>} Customer ID )
pradosh_thakur
Honored Contributor II

Re: Calcalate Customer Retention Rate

Make sure [purchase date] is in date format and not string.

count(distinct {<[Purchase Date]={">$(=AddMonths(Today(),-5))"}>} [Customer ID] )

 

 

Learning never stops.
prabunakil
New Contributor III

Re: Calcalate Customer Retention Rate

 Date(Floor( Date(AddedDate)),'DD/MM/YYYY') as PurchaseDate,

 

My Purchase Date is as per above. 

prabunakil
New Contributor III

Re: Calcalate Customer Retention Rate

I follow ur dimension and i getting as below:

 Annotation 2019-02-12 215752.jpg

 

prabunakil
New Contributor III

Re: Calcalate Customer Retention Rate

Hi, i am still unable to calculate it.