Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlikview Gurus,
I am new on Qlikview infact it is my first BI tool on which i am working
well i am looking for help to draw a graph in Qlikview although it gives me an option to draw some simple graphs but i want to draw some trend analysis graphs which base on mulitple columns.
Here is a sample data on the basis of which i want to develop those graphs. From the data below i want to put the Size on Y-axis and ST1,2,34,5,6,7,8,9,10 on X-axis .
| Size | ST1 | ST2 | ST3 | ST4 | ST5 | ST6 | ST7 | ST8 | ST9 | ST10 |
| 1 GB | 79.5 | 119.2 | 79.5 | 95.4 | 158.9 | 119.2 | 95.4 | 119.2 | 119.2 | 119.2 |
| 1 GB | 79.5 | 159 | 68.1 | 95.4 | 119.2 | 158.9 | 95.4 | 158.9 | 119.2 | 95.4 |
| 10 GB | 68.1 | 119.2 | 79.5 | 95.4 | 119.2 | 95.4 | 68.1 | 119.2 | 119.2 | 79.5 |
| 10 GB | 79.5 | 158.9 | 68.1 | 119.2 | 95.4 | 95.4 | 79.5 | 159 | 95.4 | 68.1 |
| 20 GB | 68.1 | 119.2 | 79.5 | 95.4 | 119.2 | 79.5 | 68.1 | 119.2 | 119.2 | 68.1 |
| 20 GB | 79.5 | 119.2 | 68.1 | 95.4 | 95.4 | 68.1 | 79.5 | 119.2 | 95.4 | 79.5 |
| 30 GB | 68.1 | 95.4 | 79.5 | 95.4 | 119.2 | 79.5 | 79.5 | 119.2 | 95.4 | 79.5 |
| 30 GB | 79.5 | 95.4 | 68.1 | 119.2 | 95.4 | 68.1 | 79.5 | 119.2 | 119.2 | 68.1 |
| 40 GB | 68.1 | 68.1 | 79.5 | 95.4 | 95.4 | 79.5 | 79.5 | 119.2 | 119.2 | 79.5 |
| 40 GB | 79.5 | 79.5 | 79.5 | 119.2 | 95.4 | 68.1 | 79.5 | 119.2 | 119.2 | 68.1 |
| 50 GB | 68.1 | 68.1 | 79.5 | 95.4 | 95.4 | 68.1 | 79.5 | 119.2 | 119.2 | 68.1 |
| 50 GB | 79.5 | 79.5 | 68.1 | 119.2 | 95.4 | 79.5 | 68.1 | 95.4 | 119.2 | 79.5 |
| 60 GB | 68.1 | 79.5 | 79.5 | 95.4 | 95.4 | 79.5 | 68.1 | 119.2 | 95.4 | 79.5 |
| 60 GB | 79.5 | 79.5 | 79.5 | 95.4 | 95.4 | 68.1 | 79.5 | 119.2 | 119.2 | 79.5 |
| 70 GB | 68.1 | 68.1 | 95.4 | 119.2 | 95.4 | 68.1 | 68.1 | 119.2 | 95.4 | 68.1 |
| 70 GB | 79.5 | 79.5 | 119 | 95.4 | 95.4 | 79.5 | 79.5 | 119.2 | 119.2 | 79.5 |
| 80 GB | 68.1 | 79.5 | 119 | 119.2 | 95.4 | 68.1 | 95.4 | 119.2 | 119.2 | 68.1 |
| 80 GB | 79.5 | 68.1 | 95.4 | 95.4 | 119.2 | 79.5 | 119.2 | 119.2 | 119.2 | 79.5 |
| 90 GB | 95.4 | 68.1 | 95.4 | 119.2 | 119.2 | 79.5 | 119.2 | 119.2 | 119.2 | 79.5 |
| 90 GB | 95.4 | 79.5 | 119 | 95.4 | 95.4 | 68.1 | 95.4 | 119.2 | 119.2 | 68.1 |
| 99 GB | 119 | 79.5 | 158 | 119.2 | 95.4 | 68.1 | 119.2 | 119.2 | 119.2 | 95.4 |
| 100 GB | 158 | 68.1 | 158 | 159 | 95.4 | 68.1 | 95.4 | 119.2 | 119.2 | 119.2 |
Can any one pls help me out on this..?
Thanks in advance
How far have you gotten so far? Have you already loaded the excel in QV? If so, I assume you want a line graph, so create a chart and select line type. Size would be your dimension and each ST would be an expression like avg(ST1). You can then rotate the graph as you like in the Style tab.
Am I missing anything or misunderstanding any requirement?
Regards.
Hi Karl,
Thanks for your response.
Yes i have already been loaded the data from excel to QV moreover i have also made a graph but it is allowing me to select Data size and ST1. I want to plot from ST1 to ST10 in one grpah against Data size.
How i can plot all ST1 to ST10 against Data size in one single graph..?
Hi there, if I understood correctly here is you answer.
Table:
crosstable(STs,Measure,1)
Load * inline
[
Size,ST1,ST2,ST3,ST4,ST5,ST6,ST7,ST8,ST9,ST10
1 GB,79.5,119.2,79.5,95.4,158.9,119.2,95.4,119.2,119.2,119.2
1 GB,79.5,159,68.1,95.4,119.2,158.9,95.4,158.9,119.2,95.4
10 GB,68.1,119.2,79.5,95.4,119.2,95.4,68.1,119.2,119.2,79.5
10 GB,79.5,158.9,68.1,119.2,95.4,95.4,79.5,159,95.4,68.1
20 GB,68.1,119.2,79.5,95.4,119.2,79.5,68.1,119.2,119.2,68.1
20 GB,79.5,119.2,68.1,95.4,95.4,68.1,79.5,119.2,95.4,79.5
30 GB,68.1,95.4,79.5,95.4,119.2,79.5,79.5,119.2,95.4,79.5
30 GB,79.5,95.4,68.1,119.2,95.4,68.1,79.5,119.2,119.2,68.1
40 GB,68.1,68.1,79.5,95.4,95.4,79.5,79.5,119.2,119.2,79.5
40 GB,79.5,79.5,79.5,119.2,95.4,68.1,79.5,119.2,119.2,68.1
50 GB,68.1,68.1,79.5,95.4,95.4,68.1,79.5,119.2,119.2,68.1
50 GB,79.5,79.5,68.1,119.2,95.4,79.5,68.1,95.4,119.2,79.5
60 GB,68.1,79.5,79.5,95.4,95.4,79.5,68.1,119.2,95.4,79.5
60 GB,79.5,79.5,79.5,95.4,95.4,68.1,79.5,119.2,119.2,79.5
70 GB,68.1,68.1,95.4,119.2,95.4,68.1,68.1,119.2,95.4,68.1
70 GB,79.5,79.5,119,95.4,95.4,79.5,79.5,119.2,119.2,79.5
80 GB,68.1,79.5,119,119.2,95.4,68.1,95.4,119.2,119.2,68.1
80 GB,79.5,68.1,95.4,95.4,119.2,79.5,119.2,119.2,119.2,79.5
90 GB,95.4,68.1,95.4,119.2,119.2,79.5,119.2,119.2,119.2,79.5
90 GB,95.4,79.5,119,95.4,95.4,68.1,95.4,119.2,119.2,68.1
99 GB,119,79.5,158,119.2,95.4,68.1,119.2,119.2,119.2,95.4
100 GB,158,68.1,158,159,95.4,68.1,95.4,119.2,119.2,119.2
]
;
In the GUI create a line chart with:
Dimension -> Size, STs
Expression-> avg(Measure)
Regards.