Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
mlvoitik
Contributor II
Contributor II

Set Analysis Expression for Regional Sales


I have a chart that contains Region, Product and Sales. the sales amount is by product and region. I would like to add a column for regional sales based on the product selected. For example:

RegionProductSalesRegional Sales
NorthA40100
WestB5050
NorthB60100

I think I can add the new column with a Set Analysis expression. But I can't figure out the Set Analysis.  Any ideas?  Thanks!

1 Solution

Accepted Solutions
maxgro
MVP
MVP

sum (total <Region> Sales)

View solution in original post

2 Replies
maxgro
MVP
MVP

sum (total <Region> Sales)

View solution in original post

mlvoitik
Contributor II
Contributor II
Author


Thank you. That was simple and just what I needed!