topic Set Analysis: returning count(distinct State) where count(Distinct State)>=10 in QlikView

Set Analysis: returning count(distinct State) where count(Distinct State)>=10

awqvuserneo — Fri, 04 Oct 2013 15:02:54 GMT

Hi folks,

Would you kindly help me with converting this "IF" statement to set analysis? (Assuming I will need to display it in Pivot Chart" instead of "Straight Chart")

=If(count(Distinct State) >= 10, count(Distinct State), 0)

As the dimension, I will have the list of Countries. I would expect to have the result as follows:

I appreciate everyone's help on this.

Thanks in advance,

Anton

Re: Set Analysis: returning count(distinct State) where count(Distinct State)>=10

swuehl — Fri, 04 Oct 2013 15:14:15 GMT

Maybe like

=count({<Country = {"=count(DISTINCT State)>=10"}>} DISTINCT State)

Re: Set Analysis: returning count(distinct State) where count(Distinct State)>=10

Fri, 04 Oct 2013 15:16:17 GMT

Hi,

I would do:

count({<State ={"count(distinct State)> 10"} distinct State)

Try this

Fabrice

Re: Set Analysis: returning count(distinct State) where count(Distinct State)>=10

awqvuserneo — Fri, 04 Oct 2013 17:08:26 GMT

Thanks swuehl & Fabrice for your quick respond. It works!