Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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!
Hi Lachmacjbl,
Plz let me knw if nw u r able to achive wht u wanted.
Thanks for updating the Status of ur Problem.
Sorry for not updating sooner. Yes, it is now working fine. Thanks.