Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
lironbaram
Honored Contributor II

Re: New customers in month

hei

attach i an example

try it

4 Replies
lironbaram
Honored Contributor II

Re: New customers in month

hei

attach i an example

try it

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

Highlighted
lironbaram
Honored Contributor II

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.

Community Browser