x, y chart average from different fields

[#1]

Hi 

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

[hic]

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

[#3]

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.

[hic · Accepted solution]

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

[#5]

Brilliant!

Works perfectly.

Thanks for your help, Henric.

Tim.