This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I need to apply a calculation condition on a chart so it will only display when no selection is made in 2 separate fields.
The 2 fields are called:
[Payment Type Category]
[Time Category A]
Tried the following if statement but it is failing:
=if(GetSelectedCount([Time Category A])=0 or GetSelectedCount([Payment Type Category])=0,1,0)
What do you mean with 'failing'?
And do you require that both fields show no selections (then use an AND operator) or at least one shows no selection?
View solution in original post
Thanks for the quick reply Stefan.
The AND operator worked, I feel rather silly for not using that in the first place.
GetSelectedCount([Time Category A])=0 And GetSelectedCount([Payment Type Category])=0