Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?
Expression:
Count({<Flag={1}>}field)
Thanks, Nagesh.
how do I do it if I want to count if record is 'y'?
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
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"?
If you want to count item which have availability "Yes".
Use Item as a " Field".
ex- Count({<Availability={'Yes'} >} Item )
Regards
Raman
Thanks.
It shows an error in set modifier expression...
Count(if(Availability='Yes',Item)
Or
Count({<Availability={'Yes'}>}Item)
Thanks, Sasidhar.
But it still shows error.
I am using Qlik Sense. Not sure what's wrong.
Hi,
Can you share your Application with sample data ?
Thanks,
Justin.