topic QV9 Trigger Multiselect in QlikView

QV9 Trigger Multiselect

Wed, 21 Oct 2009 20:12:49 GMT

Hi,

how can I create a trigger that selects more than one field.
I tried Triggers->Edit Actions (on Activate Sheet) -> Select in Field

Is there something like and or & etc?

Thanks in advance.

Matt

Wed, 21 Oct 2009 21:00:27 GMT

as far as i know, the only way to select more than one value in a field with this action is to use a wildcard in the search pattern

for example, selecting "A*" will select all values in that field beginning with A

you can use a macro with the Field.SelectValues method to achieve more complex selection

Wed, 21 Oct 2009 21:06:40 GMT

Hi Matt,

see the attached example: On the main sheet the "Select some Weeks" button

Good luck!

Rainer

Wed, 21 Oct 2009 22:25:23 GMT

Hi,

looks good for numbers, but selecting different text values might be a problem?

Thu, 18 Mar 2010 11:09:33 GMT

Hi,

You could try the following macro for selecting multiple values from any field:

sub SelectionsProdArea

set ad = ActiveDocument

set vProdArea=ad.getfield("ProductArea")

vProdArea.clear

vProdArea.select ("100")
vProdArea.toggleselect ("200")
vProdArea.toggleselect ("400")

end sub

best regards,

Johan

Tue, 10 May 2011 14:18:55 GMT

Hi,

If you want to use a expression to generate a selection you have to make a variable.

Something like '=>27<' & week(today())

to select a financial year that starts in week 27.

In the actionfield then add $(vVariablename).

Greetz, Halmar

Tue, 10 May 2011 14:53:42 GMT

Hi Matt,

Please find an example with multiple selection through triger. Hope this is what you wanted.

Best Regards,

Sajeevan