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

12 Replies
Not applicable
Author

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!

Not applicable
Author

Hi Lachmacjbl,

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

Thanks for updating the Status of ur Problem.

Not applicable
Author

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