topic Re: Count(Distinct()) with condition in QlikView

Count(Distinct()) with condition

Thu, 26 Sep 2013 10:13:53 GMT

Hi!

I want to use COUNT(DISTINCT()) to calculate the number of clients that bought a certain product. I am using this formula, but the numbers are weird, it's not correct.

IF(CPRODUS='A19', COUNT(DISTINCT(CCLIENT)))

What to i do wrong?

Re: Count(Distinct()) with condition

manas_bn — Fri, 27 Sep 2013 05:51:09 GMT

Hi Laura,

I hope this is what you are looking for. Here goes -

You can use

IF(CPRODUS='A19', COUNT(DISTINCT CCLIENT)) OR

Count({$<CPRODUS={'A19'}>} distinct CCLIENT) OR // value changes based on selections

Count({1<CPRODUS={'A19'}>} distinct CCLIENT) // value remains same regardless of selections

But the correct value will still depend on which chart you are using and what dimensions...

Cheers,

Manas

Re: Count(Distinct()) with condition

rajeshvaswani77 — Fri, 27 Sep 2013 06:05:53 GMT

Hi,

Can you try this

count(if(CPRODUS='A19',DISTINCT(CCLIENT)))

thanks,

Rajesh Vaswani

Re: Count(Distinct()) with condition

Fri, 27 Sep 2013 06:33:43 GMT

Thanks, guys, it works now.