Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mark_perreault
Contributor II
Contributor II

Variables and Dollar Sign Expansion in a Table

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

RegionSales

North

25
South25
East 25
West25

however my result is this

RegionSales
North100
South100
East100
West100

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.

1 Solution

Accepted Solutions
sunny_talwar

declare your variable without an equal sign

vSales: Sum(Sales)

View solution in original post

3 Replies
sunny_talwar

declare your variable without an equal sign

vSales: Sum(Sales)

View solution in original post

mark_perreault
Contributor II
Contributor II
Author

Yes this works thank you!