topic Re: one button to select and deselect values in a field in QlikView

one button to select and deselect values in a field

Thu, 17 Apr 2014 13:43:46 GMT

dear all,

I can achieve the following with two separate buttons and it is a fairly easy task

fieldA: select values x,y,z

fieldA: no selections

How can I indeed have just one button doing that? You click it, it selects x,y,x, you re-click on it and all selections for that field are cleared?

thank you!

Re: one button to select and deselect values in a field

Gysbert_Wassenaar — Thu, 17 Apr 2014 13:54:40 GMT

See attached example

Re: one button to select and deselect values in a field

Thu, 17 Apr 2014 13:57:09 GMT

thanks for your effort!

but the variable is not there..

Re: one button to select and deselect values in a field

alexandros17 — Thu, 17 Apr 2014 13:58:24 GMT

Write in your action condition (Select in field)

In the upper textbox the name of your field (for example: field)

in the second textbox:

=if(GetSelectedCount(field)=0, '(A|B|C)', '')

Re: one button to select and deselect values in a field

maxgro — Thu, 17 Apr 2014 13:59:50 GMT

add an action to the button to set the state in a variable

then you select or clear depending on the variable

Re: one button to select and deselect values in a field

MK_QSL — Thu, 17 Apr 2014 14:01:02 GMT

Like this?

Re: one button to select and deselect values in a field

Gysbert_Wassenaar — Thu, 17 Apr 2014 14:01:04 GMT

Oops. Removed too much from the example. I've updated the example above.

Re: one button to select and deselect values in a field

Thu, 17 Apr 2014 14:03:27 GMT

almost perfect Alessandro

should rather be

in the second textbox:

=if(GetSelectedCount(field)=0, '(A|B|C)', '()')

with the double brackets in the last parameter of the if function

but huge thanks for pointing me in the right direction!!

Re: one button to select and deselect values in a field

Thu, 17 Apr 2014 14:07:01 GMT

thanks Gysbert, it works now!

but, it looks like magic to me, as I cannot understand how!

clicking on a button switches the variable value from 0 to -1

but where is it mapped that -1 corresponds to Jason and John?

Re: one button to select and deselect values in a field

Gysbert_Wassenaar — Thu, 17 Apr 2014 14:10:31 GMT

There's an action assigned to the OnChange trigger of the variable. You can find it on the Triggers tab of the Document Properties window.

Re: one button to select and deselect values in a field

Thu, 17 Apr 2014 14:23:56 GMT

sweet, thank you Gysbert, I was not aware of this function!

Re: one button to select and deselect values in a field

qlikviewerma — Fri, 07 Jul 2017 13:31:56 GMT

Hi Gysbert,

hi Qlik-Community,

thanks to your great description and your qvw I've managed to include the filter button in my application. The only thing I'm struggling with is that instead of selecting certain values I'd like to select/deselect all values except for one by clicking the button. Unfortunately I have no idea where I can reverse the selection.

I'm not sure whether this is the right "place" to ask for advice but I thought that it would be most suitable in here since a new thread would most likely end up in a completely different solution (meant in an unbiased way) and I somehow got the feeling that the solution above simply needs a little change to make my wish come true

Kind regards

Patric

Re: one button to select and deselect values in a field

Gysbert_Wassenaar — Sun, 09 Jul 2017 17:33:15 GMT

You can use the Select Excluded action to invert a selection.

Re: one button to select and deselect values in a field

qlikviewerma — Mon, 10 Jul 2017 07:12:57 GMT

Hi Gysbert,

thanks a lot for your advice

Kind regards

Patric

Re: one button to select and deselect values in a field

Julia_P — Tue, 18 Aug 2020 14:21:27 GMT

Hello Gysbert,

Thank you for the solution. It is really helpful but there is still an issue with it. When I clean the selection from the navigation tab or current selection box, the button itself, and the variable that stands behind it do not change accordingly. How can I solve it?

Thank you again and look forward to hearing from you.

Julia