topic Re: Help with New customer logic in pivot table in QlikView

Help with Aggr() set analysis

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

I'm trying to get the count of new customers YoY using a pivot table. The expression works fine when no selections are made. But when selections are made based on Quarter, the result varies.

E.g.:

Customer 16 is recorded as new customer in 2017 under SC1/SG4 When I select Q2, it shows up as a new customer in 2018 which is incorrect as they have already made purchase in 2017.

E.g:- Customer 17 with Item 4666ZWJWWNB3DDZ is a new Customer in Q2, 2018. But when I select Q3 it still shows up as new customer as duplicates new customer count.

I appreciate any help.Thanks!

Re: Help with New customer logic in pivot table

Arthur_Fong — Thu, 23 Aug 2018 06:09:51 GMT

Hi Sangeetha,‌

Ignoring the Quarter Selection will do.

Refer to the expression modified.

Thanks and regards,

Arthur Fong

Re: Help with New customer logic in pivot table

sangeess21 — Thu, 23 Aug 2018 13:12:14 GMT

Hi Arthur,

It works fine for Customer 16. Customer 17 with Item 4666ZWJWWNB3DDZ is a new Customer in Q2, 2018. But when I select Q3 it still shows up as new customer. That would duplicate the count when we view new customers by Quarter. Please refer attached sample.

Thanks,

Sangeetha