Discussion Board for collaboration related to Creating Analytics for QlikView.
Using a typical invoices table, I'm trying to calculate new customers in month in a chart with one dimension (Year-Month) and one expression (No of new customers)
In the expression I'm trying to compare min(Date) with min(ALL <CustomerID> Date), but I fail. The closest formula I've got is:
= count( DISTINCT
if( aggr( min(ALL <CustomerID> Date), CustomerID) = aggr( min( Date), CustomerID)
I'm getting strange results, but I feel I'm close...
Go to Solution.
attach i an example
Thanks, it works except for the first month where New Customers should be equal to ALL Customers active in that month, but your formula shows a lot more. But I can live with it...
yes and it shows all 7 cutomers who bought in the first month
Maybe I must do some tweaking for my particular case, but thank you.