topic Re: Button to select value in QlikView

Button to select value

hildacgg — Mon, 28 Sep 2015 18:09:12 GMT

How can I create a button that selects all the possible values of a field except for one?

Re: Button to select value

Gysbert_Wassenaar — Mon, 28 Sep 2015 18:18:42 GMT

Assign two actions to the button. First a Select in Field action to select one value. Then add a Select Excluded action for the same field to invert the selection.

Or use a Select Possible as the first action and the use a Toggle Select action to deselect one value. That will work unless you already have selections in that field. Then you need to add a Clear Field action as the first action.

Re: Button to select value

hildacgg — Mon, 28 Sep 2015 18:24:15 GMT

That is exactly what I did but it does not work, my field is numeric and I want to select all values that are not equal to 1

Re: Button to select value

petter — Mon, 28 Sep 2015 19:52:49 GMT

The you should try to share a sample app that illustrates your problem. Because Gysbert's advice seems correct.

Re: Button to select value

hildacgg — Tue, 29 Sep 2015 13:40:53 GMT

Here is my data,

When I click on the button nothing changes.

Invoice Exchange Rate
1
1.0954102
1.095410231
1.1101243
1.110124334
1.1102476
1.118568233
1.11931945
1.0907504
1.090750436
1.09110747
1.0911075
1.101806963
1.101807
1.1022

Re: Button to select value

Gysbert_Wassenaar — Tue, 29 Sep 2015 13:44:24 GMT

Works for me.

Re: Button to select value

hildacgg — Tue, 29 Sep 2015 13:52:21 GMT

Thank you, but is doesn't work for me, It doesn't modify my numbers, please help!

Re: Button to select value

Gysbert_Wassenaar — Tue, 29 Sep 2015 13:58:08 GMT

please help!

How? I can't read minds, never mind qlikview documents I don't have access to.

Re: Button to select value

hildacgg — Tue, 29 Sep 2015 14:04:44 GMT

Thank you so much for your answers, I don't see how to attached a document (Not Link) to the reply.

Re: Button to select value

Gysbert_Wassenaar — Tue, 29 Sep 2015 14:07:31 GMT

Click on the Use advanced editor link at the top right of the reply window. In the advanced editor you can find a link at the bottom right to attach files.

Re: Button to select value

hildacgg — Tue, 29 Sep 2015 14:11:54 GMT

Sorry, I don't see any link...

Re: Button to select value

Gysbert_Wassenaar — Tue, 29 Sep 2015 14:15:02 GMT

You won't see a link if you reply from your inbox. Open the discussion itself and there choose to reply. Then change to the advanced editor.

Re: Button to select value

hildacgg — Tue, 29 Sep 2015 14:22:51 GMT

Thank you so much for your patience, see attached docs.

Re: Button to select value

Gysbert_Wassenaar — Tue, 29 Sep 2015 14:27:31 GMT

Remove the = sign in the Field input field of both actions. So [Invoice Exchange Rate] instead of =Invoice Exchange Rate]

This I should have noticed before since you did post that already.

Re: Button to select value

hildacgg — Tue, 29 Sep 2015 14:30:06 GMT

WOW!!! Thank you so much!!!! It works perfectly!!!

Re: Button to select value

Tue, 29 Sep 2015 14:33:26 GMT

Maybe don't work because you have some text in your data. Looks the document of @hilda that i had modificated, replace the 'a 1' by '1' or 1 (on the script editor) and press the button, now it's work!!