topic Re: Trigger select fields based on multiple variables in QlikView

Trigger select fields based on multiple variables

Anonymous — Mon, 16 Jul 2012 20:16:39 GMT

Hi there!

I have various variables e.g. $(vA), $(vB), $(vC) which can be set by the user.

I want to trigger a field selection on the field e.g. City so when the Tab is opened the values of the variables above will be selected.

I created a trigger in the tab. Interestingly it works for

='('&vA&')'

but i can't get a selection based on MORE than one var like

='('&vA&')'&' '&'('&vB&')'&' '&'('&vC&')'&'

Any idea?

Andreas

MayilVahanan — Mon, 16 Jul 2012 20:38:11 GMT

HI,

Try this,

='(*'&vA&'*|*'&vB&'*|*'&vC&'*)'

Hope it helps

Anonymous — Mon, 16 Jul 2012 20:39:58 GMT

Works like a charm