Creating a stacked bar chart

[#1]

I have survey responses such as the following:

Rank your top 3

Response ID	B	C	D
Sales	3	2	0
IT	3	1	2
Finance	1	3	2
Support	2	0	1

I want to create a stacked bar chart which will have the ranks 1,2,3 along the x axis and the count of response IDs. with B,C,D identified by colours and as the legend.

Can you help?

Thanks in advance

[sunny_talwar]

Like this?

Where i used a crosstable load to transform the data in the script

Table:

CrossTable(Type, Data)

LOAD [Response ID],

     B,

     C,

     D

FROM

[https://community.qlik.com/thread/243322]

(html, codepage is 1252, embedded labels, table is @1);

[#3]

Thanks Sunny!

Is there any way to do this without doing it within the script?

[sunny_talwar]

There might be, but why do you really want to complicate your front end? AFAIK Any front end solution will require you to use synthetic dimensions with very complex expressions.

[#5]

ok thanks

[varshavig12]

Please close the thread by marking the correct answer.