Solved: Re: how to countif - Qlik Community

Anonymous · ‎2018-09-25

How do I do a countif field is 'y' in Qlik sense?

And could you point me to the "manual" where syntax and functions are shown?

Thanks a lot.

Anonymous · ‎2018-09-29

Thanks, all.

Managed to figure out that it should be this:

Count({<[Availability]={'Yes'} >} [Item])

Was wondering why we need to include [ ] for both fields...Does anyone know?

nsetty · ‎2018-09-25

Expression:

Count({<Flag={1}>}field)

Anonymous · ‎2018-09-26

Thanks, Nagesh.

how do I do it if I want to count if record is 'y'?

raman_rastogi · ‎2018-09-26

You can use set analysis or if condition for this

ex-

Count({<Field Name={' Value'} >} Field)

Or

Count(if(Field name=' Value' ,Field1,Field2 ))

Regards

Raman

Anonymous · ‎2018-09-26

Thanks, Raman.

I am new.

For this table:

S/N Item Availability

1 flower Yes

2 plant No

3 laptop Yes

Count({<Availability={'Yes'} >} Field)

What should I key in for "field"?

raman_rastogi · ‎2018-09-27

If you want to count item which have availability "Yes".

Use Item as a " Field".

ex- Count({<Availability={'Yes'} >} Item )

Regards

Raman

Anonymous · ‎2018-09-27

Thanks.

It shows an error in set modifier expression...

sasiparupudi1 · ‎2018-09-27

Count(if(Availability='Yes',Item)

Or

Count({<Availability={'Yes'}>}Item)

Anonymous · ‎2018-09-27

Thanks, Sasidhar.

But it still shows error.

I am using Qlik Sense. Not sure what's wrong.

justinphamvn · ‎2018-09-28

Hi,

Can you share your Application with sample data ?

Thanks,

Justin.