Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to create 100% stacked columns with absolute number

Hello!

I need to create the chart as shown: columns have the same height, but they show different values segmented by Groups. Is it possible?

Id est, I would like to replace the percentage with the absolute values, keeping the proportion of the percentage.

Example.png

Thanks!

Elena

1 Solution

Accepted Solutions
4 Replies
sunny_talwar

May be make use of Dual() function. Something like this:

Dual(Sum(Field), Sum(Field), Sum(Total <Year> Field))

May be share a sample for more help.

Anonymous
Not applicable
Author

Thank you, but I think it doesn't work...

I attched example files.

Thanks!

Elena

sunny_talwar

This?

Capture.PNG

Anonymous
Not applicable
Author

Yes, thanks, you are very kind!

Elena