topic Re: Variable Parameters in QlikView

Variable Parameters

Wed, 03 Dec 2014 21:31:30 GMT

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.

Re: Variable Parameters

maxgro — Wed, 03 Dec 2014 21:39:11 GMT

if I undertsnad, see attachment

Re: Variable Parameters

Wed, 03 Dec 2014 22:27:10 GMT

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?

Re: Variable Parameters

maxgro — Wed, 03 Dec 2014 23:08:57 GMT

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