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
View solution in original post
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.