Calculation for customers who did not buy in the period ( QLIK SENSE )

[MatheusC]

Hello,

I have to bring a calculation of customers who buy on time and customers who left.

For customers who buy within the deadline I can use, as an example below:

count({<Annotate={"$(=Max(Annotate))"}>}distinct GroupTest),

My question is for the customers who left, would anyone know a way to bring these customers in?

Thank you very much in advance!

( QLIK SENSE )

[BrunPierre · Accepted solution]

Perhaps this

Count( {$<Annotate= E({1<Annotate={"$(=Max(Annotate))"}>})>}distinct GroupTest)

[RafaelBarrios]

Hi @MatheusC 

You could try

count({<Annotate={"<$(=Max(Annotate))"}>-<Annotate={"$(=Max(Annotate))"}>}distinct GroupTest)

which would be the same as saying, all the GroupTest that in some day before Max(Annotate) bought minus the GroupTest that bought on the date.

Also

count({1-<Annotate={"$(=Max(Annotate))"}>}distinct GroupTest)

1 is the complete set of data but will ignore all posible selections you make.

hope this helps

Best,

[MatheusC]

Thanks   @RafaelBarrios      @BrunPierre 

Apparently this expression returns the correct value, from customers who did not buy in the period. I just changed the field like below:

Count( {$< GroupTest = E({1<Annotate={"$(=Max(Annotate))"}>})>}distinct GroupTest)