Multiple Selection Based on a Variable in a Drop-Down

Mon, 28 Oct 2013 20:53:43 GMT

Hello,

I have a drop-down list that has three options:

1. all

2. group one

3. group two

I would like to

select * from table1 when a user selects 'all'

select table1.option1, table1.option2 when a user selects 'group one'

and finally

select table1.option3, table1.option4 when a user selects 'group two'

The drop-down is stored in a variable and I have tried using if in the Variable Event Triggers > Search String - but this limits me to only one select: if(vTest = 'group one', option1, option3)

Thanks in advance.

Re: Multiple Selection Based on a Variable in a Drop-Down

Josh_Good — Mon, 28 Oct 2013 22:12:46 GMT

This may be best done using bookmarks and having the variable change select the correct bookmark. If that doesn't work, can you please post a QVW so we can see what you are trying to do.

Thanks.

topic Re: Multiple Selection Based on a Variable in a Drop-Down in QlikView

Multiple Selection Based on a Variable in a Drop-Down

Re: Multiple Selection Based on a Variable in a Drop-Down