Graph - newbie question

[#1]

Hello,

    I need to create a graph in qlikview, that shows performance data for various servers,

using a dataset like:

diskQueueMax	diskQueueAvg	MachineName	hour
16.97	10.93	dbclw04	2
44.88	26.02	dbclw04	21
36.32	22.66	dbclw04	18
16.82	5.02	dbclw04	8
37.16	15.08	dbclw04	1
3.22	0.66	dbclw04	4
13.02	10.04	dbclw03	2
42.78	16.42	dbclw03	18
6.79	0.77	dbclw03	5
12.25	4.43	dbclw03	8
31.88	12.64	dbclw03	1
14.23	3.52	dbclw08	16
440.18	187.31	dbclw08	7
30.89	2.37	dbclw08	0
13.37	4.91	dbclw08	20
3.68	0.9	dbclw08	23

That is, I have 2 values (diskQueueMax, diskQueueAvg) per machine per hour.

How can I display them using a line chart, that has on the x-axis the timestamp (hour)

and different lines for each machine & value.

E.g. one line for dbclw04-diskQueueMax, another for dbclw04-diskQueueAvg, another for dbclw03-diskQueueMax etc.

Thanks

[fosuzuki]

Check the attached qvw.

Hope this helps

Fernando

[#3]

Hi Fernando,

     many thanks for your report, however I need to load data from a sql database:

select round(max(value)*100,2) diskQueueMax,lower(MachineName) MachineName, datepart(hh,datetime) hour

from wmidata

where

CategoryName           = 'PhysicalDisk'

and CounterName           = 'Avg. Disk Queue Length'

group by MachineName, datepart(hh,datetime)

Can you pls advice?

Thanks

[fosuzuki]

CrossTable(Type, Value, 2)

LOAD MachineName,

     hour,

     diskQueueMax,

     diskQueueAvg;

SQL SELECT

           round(max(value)*100,2) diskQueueMax,

           round(avg(value)*100,2) diskQueueAvg,

           lower(MachineName) MachineName,

           datepart(hh,datetime) hour

from wmidata

where

           CategoryName                    = 'PhysicalDisk'

           and CounterName          = 'Avg. Disk Queue Length'

group by MachineName, datepart(hh,datetime);