topic Re: Creating a stacked bar chart in QlikView

Creating a stacked bar chart

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Creating a stacked bar chart

sunny_talwar — Wed, 14 Dec 2016 10:15:21 GMT

Like this?

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

Table:

CrossTable(Type, Data)

LOAD [Response ID],

FROM

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

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

Re: Creating a stacked bar chart

Wed, 14 Dec 2016 10:20:54 GMT

Thanks Sunny!

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

Re: Creating a stacked bar chart

sunny_talwar — Wed, 14 Dec 2016 10:23:25 GMT

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.

Re: Creating a stacked bar chart

Wed, 14 Dec 2016 10:24:33 GMT

ok thanks

Re: Creating a stacked bar chart

varshavig12 — Wed, 14 Dec 2016 10:56:06 GMT

Please close the thread by marking the correct answer.