topic Stacked bar chart in QlikView

Stacked bar chart

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

I'm struggling to show a data on a stacked bars chart, I have the data in the follwoing format:

Id	Location	Sector1 Risk Level	Sector2 Risk Level	Sector3 Risk Level
1	Location1	High	Low	Low
2	Location2	Low	Low	Low
3	Location3	Low	Medium	Low
4	Location4	Low	Medium	High
5	Location5	Medium	Medium	High
6	Location6	Medium	Medium	High
7	Location7	Low	High	Medium
8	Location8	High	Low	Medium

What would be the best way to show the data on stacked bars so that X-axis has: 'Sector1 Risk Level', 'Sector2 Risk Level' and 'Sector3 Risk Level' dimensions, then the risk levels count will be displayed on stacked bars per each sector?

Thanks.

Re: Stacked bar chart

sunny_talwar — Wed, 08 Mar 2017 16:26:37 GMT

Used a The Crosstable Load to transform the data and then used this

Dimensions

Sector

Risk Level

Expression

Count(Id)

Re: Stacked bar chart

Aurelien_Martinez — Wed, 08 Mar 2017 16:30:47 GMT

Hi,

You can try:


CrossTable(Sector, [Risk Level], 2)
LOAD Id, 
     Location, 
     [Sector1 Risk Level], 
     [Sector2 Risk Level], 
     [Sector3 Risk Level]
FROM
[https://community.qlik.com/thread/252587]
(html, codepage is 1252, embedded labels, table is @1);

Re: Stacked bar chart

Aurelien_Martinez — Wed, 08 Mar 2017 16:32:26 GMT

stalwar1, you are faster than light ^^

Re: Stacked bar chart

amigo007 — Wed, 08 Mar 2017 20:09:27 GMT

Works great! Thanks Talwar and Martinez for your very fast help..