topic New Customer Count Expression in QlikView

New Customer Count Expression

fazunus — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

I am working on creating a new customer count expression based on the customers who were created in selected period.I have activity the table with the contact date(activity date) and the customer table with the customer creation date.

I would like to have the table output as attached in the excel sheet.

Re: New Customer Count Expression

Vegar — Tue, 22 Jan 2019 08:05:07 GMT

Try something like this.

= count({< 
         [creation date]= {">=$(=min([activity date]))<=$(=max([activity date]))"}
        > } distinct CustomerID)

You might want to expand the modifier to cancel all selection in other period dimension such as [Year] , [Month], [Week]

= count({< 
    [creation date]= {">=$(=min([activity date]))<=$(=max([activity date]))"},
    [Creation Year]=,
    [Creation Month]=,
    [Creation Week]=
    >} distinct CustomerID)

Re: New Customer Count Expression

fazunus — Tue, 22 Jan 2019 08:38:50 GMT

Dear Vegar,

Thanks for the swift response.Its working perfectly fine.

Thanks again bro.
Regards