How to add a where condition in count function of qlik view

[#1]

I have a column named a and i need to count it with some conditions. For eg., for the column a the values are,

a

---

yes

yes

yes

yes

no

no. I need to count only yes, how do i that in Qlik view. Any help would be really appreciated.

Thanks,

Praveen.

[CELAMBARASAN · Accepted solution]

Hi,

     You can use set analysis for this

     =Count({<a={'yes'}>} a) it counts yes

     =Count({<a={'no'}>} a)  it counts no

Hope it helps

Celambarasan

[v_iyyappan]

Hi,

     I attached sample QV. Hope its helpful for you.

Regards,

Iyyappan

[#4]

How would you do it if you had two conditions, ie. yes and maybe?