Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prabunakil
Contributor III
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
gn_marvs1989
Contributor III
Contributor III

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
Master II
Master II

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

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

 

 

Learning never stops.
prabunakil
Contributor III
Contributor III
Author

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

 

My Purchase Date is as per above. 

prabunakil
Contributor III
Contributor III
Author

I follow ur dimension and i getting as below:

 Annotation 2019-02-12 215752.jpg

 

prabunakil
Contributor III
Contributor III
Author

Hi, i am still unable to calculate it.