Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
fabdulazeez
Partner - Creator III
Partner - Creator III

Always one selected, ignore selection

I have a field with "Always One Selected Value" enabled. I want to display all possible values in the field that satisfy a specific condition, in a  filter pane, while ignoring the selection. Can this be achieved using the Aggr function?

I tried below but the filter becomes checkbox instead of radio button
=Aggr({1} only({1}
if(WildMatch([_DimArrivalAreas],'*baggage*'),[_DimArrivalAreas])),[_DimArrivalAreas])

fabdulazeez_0-1735817406935.png

 

 

Labels (3)
1 Solution

Accepted Solutions
Or
MVP
MVP

This will work in that it'll display the right values, but you won't be able to make regular selections. You'll have to make selections using CTRL+click (Override) for it to work. My understanding is that Qlik does not recognize the calculated formula as the underlying field (until you make and approve the selection, anyway), so it doesn't know you're trying to make a selection on a field that has always one selected value.

 

View solution in original post

1 Reply
Or
MVP
MVP

This will work in that it'll display the right values, but you won't be able to make regular selections. You'll have to make selections using CTRL+click (Override) for it to work. My understanding is that Qlik does not recognize the calculated formula as the underlying field (until you make and approve the selection, anyway), so it doesn't know you're trying to make a selection on a field that has always one selected value.