topic SUM After Distinct Count in QlikView

SUM After Distinct Count

vijayit43 — Thu, 11 Sep 2014 02:08:23 GMT

Dear All,

In My Qv we create pivot dimension field is state,DistributorCode,RetailerCode,brand and expression field is count(distinct brand) when we expend brand level then give right answer which we want and when we collapse state level then also distinct count but we want when we collapse state level then distinct count only retailercode level after that it sum that count how to possible please help ..

for refrence attach qv

Re: SUM After Distinct Count

preminqlik — Thu, 11 Sep 2014 02:51:41 GMT

hi use this exp

hope this helps you

sum(aggr(count (distinct Brand),State,DistributorCode,RetailerCode,Brand))

Re: SUM After Distinct Count

jagan — Thu, 11 Sep 2014 03:39:23 GMT

Hi Vijay,

I think count (distinct RetailerCode) makes sense, you will get the required values.

Regards,

Jagan.