topic Macro to get selected values in a variable in QlikView

Macro to get selected values in a variable

oxiofrt — Wed, 23 Sep 2009 00:57:16 GMT

Hi,
my application is containing several listboxes. I would like to have a variable SELECTED_VALUES which would contain all selected values in those listboxes.

Principa would be that each time a value is selected in any of these listboxes, variable would take its previous value ('' at the beginning) concatenated to the new selection operated. That is to say that the order the user is selecting value in the listboxes has to be taken into account.

Herejoined is an application that should make the understanding of the matter easier.

Thanks a lot for your help, it aims to provide disable people to express by themselves better.

Macro to get selected values in a variable

markmccoid — Wed, 23 Sep 2009 01:36:25 GMT

Hi,

I'm not exactly sure what you were looking for, but I modified your attached application to show one way I might accomplish this.

I just set this up to work with the first list box, but you could extend it to others.

First, I made the listbox so only one value could be selected at a time. Then I created a Macro called AppendtoVar and set it to fire whenever the Qui field had a OnSelect event happen.

The ClearVar button will clear the variable.

I'm sure there are issues to work out and this may not be what you need, but thought it might help you in some way.

Macro to get selected values in a variable

oxiofrt — Wed, 23 Sep 2009 13:28:42 GMT

That's it !

Only missing thing would be to be able to select values in each listboxes and not the first one (Qui?).

Is is possible ?

Thanks a lot for your help !

Macro to get selected values in a variable

markmccoid — Wed, 23 Sep 2009 19:06:17 GMT

Hi,

I've attached the example again and extended it to the first two list boxes. You would just need to create a macro for each of the list boxes and set the Macros to fire when the OnSelect event is triggered for each field.

Hope this helps.

Macro to get selected values in a variable

oxiofrt — Wed, 23 Sep 2009 19:25:42 GMT

Thanks a lot for your help, it's just what I was waiting for.

GREAT