Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
elena888
Valued Contributor

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

Re: How to create 100% stacked columns with absolute number

This?

Capture.PNG

4 Replies

Re: How to create 100% stacked columns with absolute number

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.

elena888
Valued Contributor

Re: How to create 100% stacked columns with absolute number

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

I attched example files.

Thanks!

Elena

Re: How to create 100% stacked columns with absolute number

This?

Capture.PNG

elena888
Valued Contributor

Re: How to create 100% stacked columns with absolute number

Yes, thanks, you are very kind!

Elena