Stacked bar chart

[amigo007]

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.

[sunny_talwar · Accepted solution]

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

Dimensions

Sector

Risk Level

Expression

Count(Id)

[Aurelien_Martinez]

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);

[Aurelien_Martinez]

stalwar1, you are faster than light ^^

[amigo007]

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