Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Isabelaa_123
Contributor II
Contributor II

Limit the selection in botton selection

Hi,

I need help in my problem.

I have a selection on the sheet for the selection of 3 categories. I would like to prevent users from choosing other options. I'm sending an example

Isabelaa_123_0-1654269248654.png

I would like the user to be able to choose, for example:

1. vodka and beer

or

2. only beer

or

3. rum and vodka

 

but could not choose wine and champagne.

 

is there such a functionality in Qlik?

 

 

 

 

 

 

 

Labels (2)
4 Replies
rubenmarin

Hi, you can create a field realted with this one, but only with selectable values, and show this one for selections:

If(Match(category,'beer','rum','vodka'), category) as SelectCategory.

But if the original category is shown in any chart they will have the possibility to check them.

vinieme12
Champion III
Champion III

This is not possible at the moment

Creating a separate field will make the values in other fields as "Excluded" values rather than "Alternate" values

 

You can however incorporate this in your expression to always include Wine and Champagne in calculations as below

syntax

=sum({<Category=p({<Category={'Wine','Champagne'}>}Category)+p(Category),OtherDim={'Otherfilter'}>} SomeValue)
Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Isabelaa_123
Contributor II
Contributor II
Author

Yes, but your solution will not allow you to choose only, for example, the category of wine.

 

and I would like to allow the user to choose

 

vinieme12
Champion III
Champion III

Your original description does not state this new criteria of selecting only Wine / Champagne at all !! 

It states "but could not choose wine and champagne."

Anyway, You can try using a variable too 

If only wine or only champagne is selected then set variable value = either 'Wine' or 'Champagne' 

If nothing is selected then set variable value ='Wine','Champagne' 

If some value except wine/champagne is selected then set variable value to= concat ('selectedvalues')+'Wine','Champagne' 

 

Then use variable in expression

=sum({<Category={$(YourVariable)},OtherDim={'Otherfilter'}>} SomeValue)

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.