topic Re: Help with Aggr() in QlikView

Help with Aggr()

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 within the same year, the result varies hence duplicating the count.

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 and duplicates new customer count by Quarter.

Any help is appreciated.

Thanks,

Sangeetha

Re: Help with Aggr()

sunny_talwar — Mon, 27 Aug 2018 17:10:26 GMT

Try this may be

Sum(Aggr(If(Customer.Mth_Year = Min({<Customer.QTR=,Customer.Month=, Customer.Year>}TOTAL <[Direct/Indirect Customer Name],[Direct/Indirect],[Service Class],[Service Group]> Customer.Mth_Year), 1, 0),[Direct/Indirect],[Service Class],[Service Group],[Direct/Indirect Customer Name], Customer.Mth_Year))

Re: Help with Aggr()

sangeess21 — Mon, 27 Aug 2018 17:44:59 GMT

It's working fine now. Thanks a lot. I really appreciate it