topic Re: Variables and Dollar Sign Expansion in a Table in App Development

Variables and Dollar Sign Expansion in a Table

Anonymous — Thu, 29 Mar 2018 18:01:50 GMT

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.

Re: Variables and Dollar Sign Expansion in a Table

sunny_talwar — Thu, 29 Mar 2018 18:08:08 GMT

declare your variable without an equal sign

vSales: Sum(Sales)

Re: Variables and Dollar Sign Expansion in a Table

Anonymous — Thu, 29 Mar 2018 18:08:39 GMT

Yes this works thank you!

Re: Variables and Dollar Sign Expansion in a Table

sunny_talwar — Thu, 29 Mar 2018 18:10:24 GMT