Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Check the attached qvw.
Hope this helps
Fernando
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
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);