Using two variables in the condition

shyamcharan — Fri, 05 Dec 2014 03:30:30 GMT

Hi Experts,

I have scenario where I need to compare two variables and use that expression in the list box.

First variable would have the result of list of values based on condition.

the next list box should show the result of list of values of First variable VARIABLE1 based on another condition.

How can i achieve this?

$(vKeyWord) would have list of values seperated by comma.

$(vKeyWordTwo) would have list of different values seperated by comma

Variablle1=Aggr(only({<Functional_Location={$(vKeyWord)}>}Functional_Location),Functional_Location)

Now I need to created one more variable like Variable2 like

Variable2=Aggr(only({<Variablle1={$(vKeyWordTwo)}>}Variablle1),Variablle1)

Thanks heaps in advance.

Regards,

Shyam

Re: Using two variables in the condition

marcus_sommer — Fri, 05 Dec 2014 11:00:05 GMT

Generally this should work but it could be difficult to create the appropriate lists and variables-syntax. In your case you will probably need $-expansion for your variables, maybe so:

$(=$(var))

$(='$(var)')

$(=var)

Have a look here to explanations and examples:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/04/the-magic-of-variables

http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/18/dollar-expansions

Dynamic Field Expressions with Variables

- Marcus

topic Using two variables in the condition in QlikView

Using two variables in the condition

Re: Using two variables in the condition