topic How to Draw a graph by selection multiple columns from excel sheet in QlikView

How to Draw a graph by selection multiple columns from excel sheet

Fri, 04 Mar 2011 17:15:03 GMT

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 to Draw a graph by selection multiple columns from excel sheet

pover — Fri, 04 Mar 2011 18:16:21 GMT

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.

How to Draw a graph by selection multiple columns from excel sheet

Fri, 04 Mar 2011 21:10:23 GMT

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

How to Draw a graph by selection multiple columns from excel sheet

Fri, 04 Mar 2011 23:15:43 GMT

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.