Limit the selection in botton selection

[Isabelaa_123]

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

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?

[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]

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)

[Isabelaa_123]

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]

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)