Qlik Community

Qlik Sense App Development

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

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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 )
Highlighted
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.
Highlighted
Contributor III
Contributor III

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

 

My Purchase Date is as per above. 

Highlighted
Contributor III
Contributor III

I follow ur dimension and i getting as below:

 Annotation 2019-02-12 215752.jpg

 

Highlighted
Contributor III
Contributor III

Hi, i am still unable to calculate it.