topic Toggle Select in QlikView

Toggle Select

richard_chilvers — Tue, 09 Sep 2014 09:37:42 GMT

Can anyone explain to me what Toggle Select does as a button action?

I have looked on the forum but all topics seem to refer to managing the toggle manually, ie. switching from one value to another then back again.

I'm basically looking for a button action which makes a field selection when clicked, and then clears the selection when clicked again.

Thanks for any advice

Richard

Re: Toggle Select

alexandros17 — Tue, 09 Sep 2014 09:48:03 GMT

1) set a variable: LET myVar = 0;

2) in the button set the action add -> selection -> select in field; in the upper textbox write the name of your field, in the lower textbox write : if(myVar=0, '', 'myValue')

where myValue is the value to which you want to set your field.

Let me know

Re: Toggle Select

rubenmarin — Tue, 09 Sep 2014 09:58:07 GMT

Hi Richard

It changes the selection state of the values

Example:

If you have a field 'year' with '2013' and '2014' selected.

Then if you use the 'Toggle Select' action with in field year with 2013 value, the 2013 value is de-selected and 2014 remains selected.

If you use again the action, 2013 is selected again. (2014 keeps selected)

Regards.

Re: Toggle Select

maxgro — Tue, 09 Sep 2014 10:00:21 GMT

if I understand, in the attachment some example

Re: Toggle Select

richard_chilvers — Tue, 09 Sep 2014 10:00:27 GMT

Hi Allessandro

Thanks for your prompt response. I have used the method you have described several times.

However, if you look under the Action list for a button, there is an action specifically called 'Toggle Select'. I cannot find any descritpion of how this works.

Regards

Re: Toggle Select

alexandros17 — Tue, 09 Sep 2014 10:16:30 GMT

Ruben Marin has yet described the logic before,

when you use toggle select, you specify a field (Customer for example) and a value to filer the field (SONY for Example)

when you click once on the button the filter "SONY" is applied on the field Customer, if you click again the filter is removed