This content has been marked as final. Show 3 replies
I have a question regarding variable and dollar sign expansion within a table in Qlik. I have created a variable vSales = sum(Sales) . I then have a table with the dimension being region and the measure being $(vSales). I'd ideally want to my table to look like this
however my result is this
The value for each region is the value for the whole dataset instead of being broken down by dimension.
I understand I can just use sum(Sales) as my measure in the table however I am wondering if it possible to use variables and dollar sign expansion.
Can anyone advise.