12 Replies Latest reply: Sep 26, 2011 2:04 PM by carl lachmann

# Line graph, using column average as points on the line

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...

• ###### Re: Line graph, using column average as points on the line

pLz upload the Diagram again.

Also Refer the Attached File.

• ###### Re: Line graph, using column average as points on the line

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

• ###### Line graph, using column average as points on the line

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

• ###### Line graph, using column average as points on the line

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

• ###### Line graph, using column average as points on the line

Use this in ur Script:

CrossTable(Aspects, Data)

Colors.xlsx

(ooxml, embedded labels, table is Sheet1);

In front End:

use Line Chart

Dimension : Aspects

Type

Expression: Avg(Data)

In display option:Enable Checkbox >Line

>Symbol

• ###### Line graph, using column average as points on the line

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

• ###### Line graph, using column average as points on the line

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

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

• ###### Re: Line graph, using column average as points on the line

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

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

• ###### Line graph, using column average as points on the line

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!

• ###### Line graph, using column average as points on the line

Success! I can now get the table up, and am now working on the formatting end. The Cross Table was a bit of an epiphany, thanks for your help!

• ###### Line graph, using column average as points on the line

Hi Lachmacjbl,

Plz let me knw if nw u r able to achive wht u wanted.

Thanks for updating the Status of ur Problem.

• ###### Line graph, using column average as points on the line

Sorry for not updating sooner. Yes, it is now working fine. Thanks.