Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

linegraph.gif

View solution in original post

12 Replies
Not applicable
Author

pLz upload the Diagram again.

Also Refer the Attached File.

Not applicable
Author

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

linegraph.gif

Not applicable
Author

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

Not applicable
Author

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
Author

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
Author

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
Not applicable
Author

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

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

Not applicable
Author

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
Author

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!