topic Line graph, using column average as points on the line in QlikView

Line graph, using column average as points on the line

Sun, 29 May 2011 21:38:06 GMT

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

Mon, 30 May 2011 04:44:53 GMT

pLz upload the Diagram again.

Also Refer the Attached File.

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

Mon, 30 May 2011 06:06:41 GMT

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

Line graph, using column average as points on the line

Mon, 30 May 2011 06:20:56 GMT

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

Mon, 30 May 2011 06:44:50 GMT

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

Mon, 30 May 2011 07:14:42 GMT

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

Line graph, using column average as points on the line

Mon, 30 May 2011 12:33:55 GMT

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.

Line graph, using column average as points on the line

Anonymous — Mon, 30 May 2011 12:42:47 GMT

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

Mon, 30 May 2011 13:05:23 GMT

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

Mon, 30 May 2011 20:30:12 GMT

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

Tue, 31 May 2011 08:25:47 GMT

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

Tue, 31 May 2011 08:49:12 GMT

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

Mon, 26 Sep 2011 18:04:49 GMT

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