topic Re: Limit the selection in botton selection in App Development

Limit the selection in botton selection

Isabelaa_123 — Fri, 03 Jun 2022 15:17:45 GMT

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

2. only beer

3. rum and vodka

but could not choose wine and champagne.

is there such a functionality in Qlik?

rubenmarin — Sat, 04 Jun 2022 07:28:34 GMT

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 — Mon, 06 Jun 2022 04:03:40 GMT

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 — Tue, 07 Jun 2022 12:11:50 GMT

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 — Tue, 07 Jun 2022 13:18:16 GMT

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)