Line graph, using column average as points on the line

[#1]

Hi,

In Excel, I use a line graph. The data (in excel) is;

Type	Aspect 1	Aspect 2	Aspect 3	Aspect 4	Aspect 5	Aspect 6
blue	6	5	2	5	3	3
green	7	6	5	5	5	5
yellow	7	6	6	5	6	7
green	7	6	5	7	6	7
blue	6	5	4	6	4	4
yellow	7	7	7	7	7	7
green	6	5	6	4	5	5
blue	4	4	2	4	2	2
blue	7	6	5	7	5	4
yellow	7	6	6	6	6	6
green	6	6	7	6	6	7
green	7	6	5	6	5	7
blue	4	3	3	3	3	2
blue	6	6	7	7	7	7

From the data I use the formula in excel "averageif" to make the next table;

Type	Aspect 1	Aspect 2	Aspect 3	Aspect 4	Aspect 5	Aspect 6
blue	5,50	4,83	3,83	5,33	4,00	3,67
green	6,60	5,80	5,60	5,60	5,40	6,20
yellow	7,00	6,33	6,33	6,00	6,33	6,67

An from this I can plot a diagram, like the one below;

It would be ever so nifty if I could do this using Qlikview, but I have not been able to find out how to get the x-axis values be those of the column headings. I am guessing the it should be relatively easy, but being a newbie, it all seems kinda tricky...

[#2]

pLz upload the Diagram again.

Also Refer the Attached File.

[#3 · Accepted solution]

Hello, I paste the chart here as a picture, hoping it will work better.

[#4]

Refer to the attached application  above .It displays the Same chart as required by u.

[#5]

Hi, thanks. Since I am running the "personal edition" I could not open it. Is there a way to get around that problem?

Best regards, Carl

[#6]

Use this in ur Script:

CrossTable(Aspects, Data)

LOAD * FROM

Colors.xlsx

(ooxml, embedded labels, table is Sheet1);

Then reload

In front End:

use Line Chart

Dimension : Aspects

                  Type

Expression: Avg(Data)

In display option:Enable Checkbox >Line

                                                   >Symbol

[#7]

Hi,

I am getting there! But not all the way...I am still not clear on how I select the first row (=the column headings) as a dimension. When I go to select dimensions, each of the column headings show up as one dimension, in other words  - Aspect 1, Aspect 2 etc - how can I select them all as one dimension?

Sorry for appearing confused, I hope to learn.

C

[Anonymous]

Can't you not just remove "Aspect" from your dimension?

That way you only have "Type" as a dimension.

[#9]

i can't understand what u want...??

When u select ' Blue ' from Dimension 'Type' then u vil get the data only for blue.

[#10]

Hi E,

thanks for your replies. I will need to try out a few things around cross tables, and will post back with how I am doing!