Field as a Variable giving wrong result

[techvarun]

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

[StarinieriG · Accepted solution]

Hi,

you have to use [ ]

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

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