topic Re: Setting up multiple buttons to create combined selections in a table in QlikView

Setting up multiple buttons to create combined selections in a table

Thu, 07 Jan 2016 13:00:39 GMT

Hi there,

How to configure two or more Buttons in a way that each of their corresponding selections values are added to the current selection of a table?

Behaviour should be working like a mouse in a Listbox holding down the STRG Key to select/unselect values.)

Example:

Field is called "Colours", containing values i.e. "RED, BLUE, GREEN, YELLOW, BLACK, ...."

Want to combine many buttons such as:

Buttons: "Select RED" "Unselect RED"

Buttons: "Select BLUE" "Unselect BLUE"

Buttons: "Select GREEN" "Unselect Green"

Clicking on the "Select RED" button should select all REDs in my table "Colours".

Expected result: REDs are listed (easy)

Clicking on the "Select BLUE" button should select all BLUEs in addition to the existing selection. In this case containing all the already selected REDs as well.

Expected Result: REDs AND BLUEs are listed

Clicking on the "Select GREEN " button should select all BLUEs in addition to the existing selection. In this case containing all the already selected REDs and BLUEs as well.

Expected Result: REDs AND BLUEs AND GREENs are listed.

...to be continued with many more buttons...

Clicking on the "Unselect RED" button should unselect all REDs from the existing selection.

Expected Result: BLUEs AND GREENs are listed.

How to achieve that?

Any help is much appreciated.

Many thx in advance

Josi

Re: Setting up multiple buttons to create combined selections in a table

MarcoWedel — Fri, 08 Jan 2016 01:04:30 GMT

Hi,

I guess this could be achieved with some variables, expressions to create search strings and field selection actions.

On the other hand you might as well use a ListBox with selection style "LED or windows check boxes":

hope this helps

regards

Marco

Re: Setting up multiple buttons to create combined selections in a table

Fri, 08 Jan 2016 08:14:45 GMT

Hi Marco,

Thx for your quick answer.

Of course, this is some sort of good workaround.

If one is going into your direction, two questions come to my mind:

1st) How to reduce/define "Colours" to be selected in the LED-Listbox (as their might be many more entries one does not care about)?

2nd) How selected/unselect different values in a convenient way, if one has no Keyboard/Mouse (i.e. on a tablet)?

Thx for your ideas.

Jörg

Re: Setting up multiple buttons to create combined selections in a table

MarcoWedel — Fri, 08 Jan 2016 23:47:44 GMT

Hi,

maybe like this:

hope this helps

regards

Marco

Re: Setting up multiple buttons to create combined selections in a table

Mon, 11 Jan 2016 09:45:49 GMT

Hallo Marco,

Thank you very much.

This is a marvellous Workaround.

Even on an iPad touching the filter works.

Good hint!

Regards,

Jörg