Distinct Count when collapse

vijayit43 — Wed, 10 Sep 2014 11:58:04 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: Distinct Count when collapse

maxgro — Wed, 10 Sep 2014 12:05:44 GMT

seems to me you want to sum the distinct brand by state and customer

sum(aggr(count (distinct brand), state, customer))

topic Distinct Count when collapse in QlikView

Distinct Count when collapse

Re: Distinct Count when collapse