3 Replies Latest reply: Jan 18, 2013 7:22 AM by Fernando Suzuki RSS

    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

        • Re: Graph - newbie question
          Fernando Suzuki

          Check the attached qvw.

           

          Hope this helps

          Fernando

            • 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

                • Re: Graph - newbie question
                  Fernando Suzuki

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