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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Swarup_MOA
Contributor III
Contributor III

Limit a filter to always have exactly one selection without using “Always one selected value”

Hi everyone,

I’m working in Qlik Sense and looking for a way to restrict a filter (or selection behavior) so that exactly one value is always selected, but without enabling “Always one selected value” in the field properties.

The reason I can’t use Always one selected is that it causes side effects in my app (unexpected automatic selections / user confusion when clearing filters).

Labels (4)
3 Replies
Vegar
MVP
MVP

I am not sure what you are trying to do? You want to force the app to always have one value selected without using the built in features always one selected value? Will the ysers not run into the same issues with automatic selections and clearing  all values using this custom feature? Or how do you want this custom feature to behave differently?

Vegar
MVP
MVP

An alternative way forward without selections could be to force your expressions to only consider one value.

You could add a show condition to each object, that only when one value is selected the object will surface.

Or you could make the all your expression only to consider one of the values by set analysis, like below. Then you don't need to have one selected, but it will take the one of the values in your selections into consideration when calculating.

{<your_field={'$(=maxstring(your_field))'}>}

AdamBS
Partner - Creator
Partner - Creator

I like the reply.  For me, I would rather mask the always one selected into a variable.  The variable acts as a default selection, the user selecting another value adjusts the variable from this default.  Then, as Vegar says, you need to enforce the always one with some set analysis.

Adam Barrie-Smith
iOCO Analytics Solutions