Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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 .

SizeST1ST2ST3ST4ST5ST6ST7ST8ST9ST10
1 GB79.5119.279.595.4158.9119.295.4119.2119.2119.2
1 GB79.515968.195.4119.2158.995.4158.9119.295.4
10 GB68.1119.279.595.4119.295.468.1119.2119.279.5
10 GB79.5158.968.1119.295.495.479.515995.468.1
20 GB68.1119.279.595.4119.279.568.1119.2119.268.1
20 GB79.5119.268.195.495.468.179.5119.295.479.5
30 GB68.195.479.595.4119.279.579.5119.295.479.5
30 GB79.595.468.1119.295.468.179.5119.2119.268.1
40 GB68.168.179.595.495.479.579.5119.2119.279.5
40 GB79.579.579.5119.295.468.179.5119.2119.268.1
50 GB68.168.179.595.495.468.179.5119.2119.268.1
50 GB79.579.568.1119.295.479.568.195.4119.279.5
60 GB68.179.579.595.495.479.568.1119.295.479.5
60 GB79.579.579.595.495.468.179.5119.2119.279.5
70 GB68.168.195.4119.295.468.168.1119.295.468.1
70 GB79.579.511995.495.479.579.5119.2119.279.5
80 GB68.179.5119119.295.468.195.4119.2119.268.1
80 GB79.568.195.495.4119.279.5119.2119.2119.279.5
90 GB95.468.195.4119.2119.279.5119.2119.2119.279.5
90 GB95.479.511995.495.468.195.4119.2119.268.1
99 GB11979.5158119.295.468.1119.2119.2119.295.4
100 GB15868.115815995.468.195.4119.2119.2119.2

Can any one pls help me out on this..?

Thanks in advance

Labels (1)
3 Replies
pover
Partner - Master
Partner - Master

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.

Not applicable
Author

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

Not applicable
Author

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.