Variable Parameters

[#1]

Hi,

I am trying to learn and understand how parameter passing works for qlikview variables. In the attached app, can someone tell me why the expressions defined in the chart as:

=$(vPickExpression('1'))

does not work?

vPickExpression variable is defined as:

=pick('$1',sum(quantity3),sum(quantity1),sum(quantity2))

but, the parameter being passed by the caller has no effect and vPickExpression always returns the result for sum(quatity3).

Thank you.

[maxgro · Accepted solution]

if I undertsnad, see attachment

[#3]

I see that all you had to do to get it to work was to remove "=" from definition of the vPickExpression variable as below: as:

pick('$1',sum(quantity3),sum(quantity1),sum(quantity2))

but, why, oh why, its working without the equal sign?

[maxgro]

it seems with equal you're evaluating the expression before you use it in the chart

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