Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Line graph, using column average as points on the line

Hi,

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

TypeAspect 1Aspect 2Aspect 3Aspect 4Aspect 5Aspect 6
blue652533
green765555
yellow766567
green765767
blue654644
yellow777777
green656455
blue442422
blue765754
yellow766666
green667667
green765657
blue433332
blue667777

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

TypeAspect 1Aspect 2Aspect 3Aspect 4Aspect 5Aspect 6
blue5,504,833,835,334,003,67
green6,605,805,605,605,406,20
yellow7,006,336,336,006,336,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...

1 Solution

Accepted Solutions
Not applicable

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.

linegraph.gif

12 Replies
Not applicable

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

pLz upload the Diagram again.

Also Refer the Attached File.

Not applicable

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.

linegraph.gif

Not applicable

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.

Not applicable

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

Not applicable

Line graph, using column average as points on the line

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

  

Not applicable

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

dennisnet
Valued Contributor III

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.

Not applicable

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.

Not applicable

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!