Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
blunckc1
Creator
Creator

Calculation condition. Multiple values.

Hi world,

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)

Solution?

Cheers

Carl

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

3 Replies
swuehl
MVP
MVP

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?

blunckc1
Creator
Creator
Author

Thanks for the quick reply Stefan.

The AND operator worked, I feel rather silly for not using that in the first place.

dsharmaqv
Creator III
Creator III

Try this

GetSelectedCount([Time Category A])=0 And GetSelectedCount([Payment Type Category])=0