Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Leverage your QlikView investment to modernize BI – see how! Join Group
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple Selection Based on a Variable in a Drop-Down


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.

1 Reply

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

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.