topic Re: Count Last Occurrences in QlikView

Count Last Occurrences

vinicius_siquei — Mon, 01 Sep 2014 20:47:12 GMT

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

Re: Count Last Occurrences

MarcoWedel — Mon, 01 Sep 2014 21:23:13 GMT

can you please provide sample data?

thanks

regards

Marco

Re: Count Last Occurrences

maxgro — Mon, 01 Sep 2014 21:54:49 GMT

hope to understand,

see attachment

Re: Count Last Occurrences

vinicius_siquei — Mon, 01 Sep 2014 23:54:27 GMT

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 ?