topic Re: Graph - newbie question in QlikView

Graph - newbie question

Fri, 18 Jan 2013 09:41:52 GMT

Hello,

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

using a dataset like:

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 — Fri, 18 Jan 2013 10:41:43 GMT

Check the attached qvw.

Hope this helps

Fernando

Fri, 18 Jan 2013 11:42:57 GMT

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 — Fri, 18 Jan 2013 12:22:48 GMT

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);