topic Re: Actions on Sheet activationh with Variables in QlikView

Actions on Sheet activationh with Variables

Fri, 29 Aug 2014 08:47:14 GMT

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:

didn't work.

Anyone got a solution for this?

Thanks

Peter

Re: Actions on Sheet activationh with Variables

tresB — Fri, 29 Aug 2014 08:52:40 GMT

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.

Re: Actions on Sheet activationh with Variables

Tue, 02 Sep 2014 13:45:48 GMT

Joop,

thanks, that works!