Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

0 Replies