How to count yes and no's

[#1]

Hi all,

just started to use QlikView and for my analysis I have to know how many

Nee (no's) and how many Ja (Yes's) there are.

As the dimension I used the month.

Now I wants to know per month how many Yes's and how many No's there are.

could you help me how the expression works for counting text? I'm such a newbie so please help 🙂

thanks in advance,

Months	Casco boven eigen risico (niet verhaalbaar)
1	Nee
1	Nee
2	Nee
2	Ja
2	Ja
3	Nee
3	Nee
3	Nee
4	Ja
4	Ja
4	Nee
4	Ja
4	Nee

[tresesco]

Use a pivot table; take first dimension as Month, 'Casco boven eigen risico' as second and use Count(DISTINCT[Casco boven eigen risico]) as expression.

Assuming 'Casco boven eigen risico' is your field name that has 'Yes'/'No' values.

[israrkhan]

Hi,

Find the Attached File, i used option instead of Casco boven eigen risico (niet verhaalbaar)

[janardhan]

hi ,

Please find the below attachment, hope this will helps!!!!

[#5]

A quick and dirty way is just to use straight table with Month as dimension and 2 exs as below:

ex1: count(if( [Casco boven eigen risico (niet verhaalbaar)] = 'Nee', (1)))

ex2: count(if( [Casco boven eigen risico (niet verhaalbaar)] = 'Ja', (1)))

[annafuksa1]

Look at attach file. I made 2 different solutions.

[Gysbert_Wassenaar · Accepted solution]

yes: count({<[Casco boven eigen risico (niet verhaalbaar)]={'Ja'}>} Months)

no: count({<[Casco boven eigen risico (niet verhaalbaar)]={'Nee'}>} Months)