Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

New customers in month

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)

              , CustomerID

              )

         )

I'm getting strange results, but I feel I'm close...

Tags (3)
1 Solution

Accepted Solutions
Partner
Partner

Re: New customers in month

hei

attach i an example

try it

View solution in original post

4 Replies
Partner
Partner

Re: New customers in month

hei

attach i an example

try it

View solution in original post

Not applicable

New customers in month

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...

Partner
Partner

New customers in month

yes and it shows all 7 cutomers who bought in the first month

Not applicable

New customers in month

Maybe I must do some tweaking for my particular case, but thank you.