Qlik Community

App Development

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

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
alexis
Partner - Creator III
Partner - Creator III

Question of Sum(TOTAL Sales) question

A simplified version of my issue is as follows:

I have a table of transactions and each transaction has a date (Invoice Date), Amount and a Group classification, so in summary

Dimensions: Group, Year
Measure: Amount

I want to create a bar chart with YEAR on the X axis and Group and Sales on the Y axis (stacked) as you can see below.

For each year I want to show sales by group as a portion of the TOTAL for each year and not as a percentage of the TOTAL for all years which is what I think I have done below with 

sum (Amount ) 
/
sum (Total Amount)
 

Any tips would be appreciated

_Prodata.jpg

1 Solution

Accepted Solutions
Kushal_Chawda

@alexis  may be this

sum (Amount ) 
/
sum (Total <Year> Amount)

View solution in original post

2 Replies
Kushal_Chawda

@alexis  may be this

sum (Amount ) 
/
sum (Total <Year> Amount)
alexis
Partner - Creator III
Partner - Creator III
Author

Excellent and so brilliantly simple. Set Analysis has never been simpler!

If you have a moment can you explain "how" it works? 

Thanks again

Alexis