Field as a Variable giving wrong result

techvarun — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am loading a same piece of script Directly and as a Variable and i am getting different values for the sum expression.

Attached is the qvw and source data. Please check and Provide the solution.

Thanks

Varun

Re: Field as a Variable giving wrong result

StarinieriG — Thu, 07 Nov 2019 11:33:57 GMT

Hi,

you have to use [ ]

so Qlik will load the variable as field name, instead of a value

[$(vMonth1)]
,[$(vMonth2)]