Qlik Community

Qlik Sense App Development

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

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
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.