Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Visualising typical survey data

I want to chart customer satisfaction survey results. The results are available in tabular format like this:

custidq1q2
q3
1FairGoodVery good
2PoorVery goodFair

where q1..q3 are the questions asked. The possible values for q1..q3 are Poor, Fair, Good, Very Good. I want to create a chart with 3 100% stacked bars (one for each question) showing the relative percentage of Poor, Fair, Good, Very Good.

I suspect I may have to rearrange my data in a different structure to accomplish this, but I am wondering is there a smarter way.

If I rearrange the data like this

custidquestionanswer
1q1Fair
1q2Good
1q3Very good
2q1Poor
2q2Very good
2q3Fair

then I can set my first dimension to 'question' and my second dimension to 'answer' and the measure is COUNT(custid).

Does anyone have suggestions as to whether this is possible in Qlik Sense without rearranging the data first? Thanks.

3 Replies
swuehl
MVP
MVP

You should be able to do this while loading your data in the script using

CROSSTABLE (question, answer)

LOAD custid, q1, q2,q3

FROM  ....;

rwunderlich

I think swuehl has you on the right track for loading the data. You may want to reconsider the stacked bar chart as your visualization. A Pivot grid can sometimes be a more insightful analysis of survey responses. An qvw showing both the grid an stacked bar approaches is attached.

Not applicable
Author

Thanks very much swuehl and rob. Makes sense.

Thanks for attachment too but it might be a couple of days before i get to this.