Using two variables in the condition

[shyamcharan]

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

[marcus_sommer]

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