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
| Region | Sales |
|---|
North | 25 |
| South | 25 |
| East | 25 |
| West | 25 |
however my result is this
| Region | Sales |
|---|
| North | 100 |
| South | 100 |
| East | 100 |
| West | 100 |
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.
