Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Show null when more than 1 criteria in a filter is selected

Hello guys, 

I would be very happy if I can get your assistance with something I am struggling with... 

I have a sheet with a couple of filters and a couple of visuals... I want to limit only one of the visuals to be showing null/empty/a specific message when more than one value is selected from the filters, as the data in this specific visual will only make sense if one selection is made in each of the filters. 

I don't want to limit the filter, because I need it to have the option to select more than 1 option for other purposes. 

I tried something like:

isNull(FilterName)>= 0 or 1, which kind of works, but I don't like the fact that it continues to show the visual if you make more than one selection in the filter and also the isNull works with only one parameter and I need something for two...

Thanks in advance!

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

You can use GetSelectedCount in your Calculation Condition option

if(GetSelectedCount(FilterName)<= 1,1,0)

You can then combine multiple if statements if you want to check on multiple filters

View solution in original post

2 Replies
Highlighted
Specialist II
Specialist II

You can use GetSelectedCount in your Calculation Condition option

if(GetSelectedCount(FilterName)<= 1,1,0)

You can then combine multiple if statements if you want to check on multiple filters

View solution in original post

Highlighted
Creator
Creator

Thanks very much!