Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

How to store values in Variable

Hi All,

I am trying to create a Variable but could not get what Iam supposed to. Actually, I want to save sum value in the variable in order to use in calculation.

Variable:

vTest = sum(if(COMPANYGROUPNAME = 'Industry',YEAR2_MARKET,0));

where YEAR2_MARKET is Decimal value. E.g 1400.00

If vTest = 1400; I would like to use 1400 in my Measure expression like below measure expression

sum(YEAR2_MARKETPER))/$(vTest)

Result:

Getting 0 values. What I am doing wrong above. I also put same varaible on Data load editor as well but no help.

Please help me how do I store some value in Variable so I can call other places.

Thanks.