topic Re: x, y chart average from different fields in QlikView

x, y chart average from different fields

Mon, 21 Sep 2015 14:40:59 GMT

I'm somethig of a QlikView Newbie

I have some survey response data that gives satisfaction and importance score in response to a raange of different questions.

I want to show the average scores from each of the different questions on a single x,y chart; satisfaction against importance.

I've no idea how to approach this in QlikView

In the attached spread sheet, I have the data in the form in Table 1

I guess I need to get it into the format in Table 2 (or maybe not?)

To produce the chart show.

Hope someone can help,

Tim.

ScatterChart.xls 20.0 K Preview

Re: x, y chart average from different fields

hic — Tue, 22 Sep 2015 06:59:26 GMT

You should make a scatter chart with Question as dimension and Avg( Satisfaction ) and Avg( Importance ) as expressions.

See Recipe for a Scatter Chart

HIC

Re: x, y chart average from different fields

Tue, 22 Sep 2015 09:33:01 GMT

Hi Henric

Thanks for getting back to me.

Thanks also for publishing a really clear article on scatter charts (wish I'd have seen it earlier!)

I can see how I could use 'Group' to bring all the questions into a single Dimension but can't see how to set the chart up so that Avg( Satisfaction ) and Avg( Importance ) would return the correct values for each question.

Sorry if I'm being thick!

Thanks for your help,

Tim.

Re: x, y chart average from different fields

hic — Tue, 22 Sep 2015 10:20:22 GMT

You need to load your data so you get the data model right. I would do the following:

Crosstable (Question,Satisfaction) LOAD
RecNo() as Respondent,
[Question1 Satisfaction] as Question1,
[Question2 Satisfaction] as Question2 ,
[Question3 Satisfaction] as Question3,
[Question4 Satisfaction] as Question4
FROM ScatterChart.xls (biff, embedded labels, header is 1 lines, table is Sheet1$)
Where Len([Question4 Importance])>0;

Crosstable (Question,Importance) LOAD
RecNo() as Respondent,
[Question1 Importance] as Question1,
[Question2 Importance] as Question2,
[Question3 Importance] as Question3,
[Question4 Importance] as Question4
FROM ScatterChart.xls (biff, embedded labels, header is 1 lines, table is Sheet1$)
Where Len([Question4 Importance])>0;

Then it straightforward to use the field "Question" as dimension:

HIC

Re: x, y chart average from different fields

Tue, 22 Sep 2015 12:18:55 GMT

Brilliant!

Works perfectly.

Thanks for your help, Henric.

Tim.