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: 
vinicius_siquei
Partner - Contributor III
Partner - Contributor III

Count Last Occurrences

Folks,

I'm trying to create a expression to count active customers. I need to present:

  • Customers who bought in the current (or Selected) month
  • Customers which the last purchase was on past month (or month previous to the selection)
  • Customers which the last purchase was on 2 months ago (or 2 previous to the selection)

My difficulties is related to identifying when was the last purchase dynamically, and the count.

Could anyone help me ?

Thx,

Vinicius

3 Replies
MarcoWedel

can you please provide sample data?

thanks

regards

Marco

maxgro
MVP
MVP

hope to understand,

see attachment

vinicius_siquei
Partner - Contributor III
Partner - Contributor III
Author

The example, really helps.

But If I understood it rightly, I still miss something.

For instance, the customers I count for last month must not have any purchase in this month.

I have to count the customers which had they last purchase in the period. If I'm counting customers with last purchase 2 months ago, I cannot consider customers who bought on past and current month.

Am I being clear on the idea ?

Could you please help me ?