topic Re: 100% stacked bar chart in QlikView

100% stacked bar chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a bit of a problem I need to create a graph that shows data as per below:

Europe Rest of World

Client 100% 0%

Industry 52% 48%

Portfolio 34% 66%

I can create a graph as such without a problem by using Valuelist but when the client has 100% in either Europe of Rest of World part, the rest of the graph (I mean Industry and Portfolio) will not show the part where Client has 0%

the graph will only show this:

Europe Rest of World

Client 100%

Industry 52%

Portfolio 34%

I know this sounds petty but some Clients demand to see the Rest of World % no matter what. I did somehow manage to do this before but for the love of God I cannot remember how I did it and I don't have it saved anywhere.

any ideas?

Re: 100% stacked bar chart

sunny_talwar — Wed, 11 Apr 2018 15:20:55 GMT

Would you be able to share an image of what you have and the expression you are using?

Re: 100% stacked bar chart

ychaitanya — Wed, 11 Apr 2018 15:21:24 GMT

use the expr for Rest of World as 100 - Expression for Europe

Have you tried that ?

Re: 100% stacked bar chart

sudhirpkuwar — Thu, 12 Apr 2018 05:27:28 GMT

Hi Monika,

Check this

if you can find it helpful....

Re: 100% stacked bar chart

Anonymous — Thu, 12 Apr 2018 07:45:51 GMT

this worked, thanks Sudhir