topic Re: How to use a variable in chart expresion ? in QlikView

How to use a variable in chart expresion ?

yanivvl0 — Thu, 14 Apr 2016 12:56:11 GMT

hello to all the QV Climbing ,

i have an expression : sum ( aggr ( max ( {$<Subject={1}>} if ( type38=1 or type39=1 , amount , 0 ) ) , proj_code ) )

and i want to make it dynamic by usin a variable : vIfAmount = if ( type38=1 or type39=1 , amount , 0 )

in:

sum ( aggr ( max ( {$<Subject={1}>} $(vIfAmount) ) , proj_code ) )

but i get 0 :

is there any way to make the calculation work ?

thanks .

sunny_talwar — Thu, 14 Apr 2016 12:59:04 GMT

Not sure what your exact requirement is, but try the attached

yanivvl0 — Thu, 14 Apr 2016 13:10:30 GMT

thanks

jonathandienst — Thu, 14 Apr 2016 13:10:37 GMT

The variable had no value in it,. If you assign the variable to your expression, it works correctly.

sunny_talwar — Thu, 14 Apr 2016 13:12:07 GMT

No problem at all

yanivvl0 — Sun, 17 Apr 2016 05:00:08 GMT

yea , i wrote with = , and then i delete ..