Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 )
Perhaps this
Count( {$<Annotate= E({1<Annotate={"$(=Max(Annotate))"}>})>}distinct GroupTest)
Perhaps this
Count( {$<Annotate= E({1<Annotate={"$(=Max(Annotate))"}>})>}distinct GroupTest)
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,
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)