Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
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.
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.