Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Graph - newbie question

Hello,

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

using a dataset like:

diskQueueMaxdiskQueueAvgMachineNamehour
16.9710.93dbclw042
44.8826.02dbclw0421
36.3222.66dbclw0418
16.825.02dbclw048
37.1615.08dbclw041
3.220.66dbclw044
13.0210.04dbclw032
42.7816.42dbclw0318
6.790.77dbclw035
12.254.43dbclw038
31.8812.64dbclw031
14.233.52dbclw0816
440.18187.31dbclw087
30.892.37dbclw080
13.374.91dbclw0820
3.680.9dbclw0823

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

Tags (1)
3 Replies
fosuzuki
Valued Contributor II

Re: Graph - newbie question

Check the attached qvw.

Hope this helps

Fernando

Not applicable

Re: Graph - newbie question

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
Valued Contributor II

Re: Graph - newbie question

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

Community Browser