Discussion Board for collaboration related to QlikView App Development.
I have survey responses such as the following:
Rank your top 3
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
Where i used a crosstable load to transform the data in the script
LOAD [Response ID],
(html, codepage is 1252, embedded labels, table is @1);
Is there any way to do this without doing it within the script?
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.
Please close the thread by marking the correct answer.