Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Actions on Sheet activationh with Variables

Hello,

when activating a sheet I want to set some filters with variables. One variable works fine with =$(myVar), but for setting the filter with more variables I didn't get it working:

($(my1stVar)|$(my2ndVar)|...) or ("=$(my1stVar)"|"=$(my2ndVar)"|...) or = ($(my1stVar)|$(my2ndVar)|...) or =("$(my1stVar)"|"$(my2ndVar)"|...)

didn't work.

Anyone got a solution for this?

Thanks

Peter

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Assuming your variables are having search string, try like:

='(' & $(var1)&'|'&$(var2)&'|'&$(var3)&'|'&......&')'

if your search strings have spaces in between, you have to take care of that by including double quotes.

View solution in original post

2 Replies
tresesco
MVP
MVP

Assuming your variables are having search string, try like:

='(' & $(var1)&'|'&$(var2)&'|'&$(var3)&'|'&......&')'

if your search strings have spaces in between, you have to take care of that by including double quotes.

Not applicable
Author

Joop,

thanks, that works!