Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Partner
Partner

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

Tags (3)
3 Replies
Highlighted

Re: Count Last Occurrences

can you please provide sample data?

thanks

regards

Marco

Highlighted
MVP
MVP

Re: Count Last Occurrences

hope to understand,

see attachment

Highlighted
Partner
Partner

Re: Count Last Occurrences

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 ?