2 Replies Latest reply: Apr 13, 2015 7:13 PM by Toni Kautto RSS

    hi i am very new to qlik view

      i have a data list and i want to create a chart for particular data, monthly and daily basis. i have attached the  .csv file and necessary data below, any one explain step by step ( if possible screen shot) it will b nice tutorial for learning.

       

       

      X-axis is hourly.  Norm is 2 days 24 points.  You can scale to 60 days on x axis.  It will make the point very small, but we need capability is a requirement

      The value shown will be the hourly average.  X-axis is hour.  So do we want hourly average or hourly max.   We could make this a filter and based on the filer you select it would Show hrly average

      CPU Utilization –

      GBL_CPU_SYS_MODE_UTIL – SYSCPUPCTSYSTime

      GBL_CPU_USER_MODE_UTIL - SYSCPUPCTUSERTIME

      Everything except Windows:  GBL_CPU_WAIT_UTIL – SYSCPUWAITTIME

      Windows Only - SysCpuPctIntrptTime

      Memory Utilization –

           GBL_MEM_SYS_UTIL (SYSMEMPHYSPCTSYS)

           GBL_MEM_USER_UTIL (SYSMEMPHYSPCTUSER)

           GBL_MEM_CACHE_UTIL (SYSMEMPHYSPCT) this metric will be Null for Solaris systems.

      I/O Rate –

      GBL_DISK_PHYS_READ_RATE (SysDiskPhysReadRate)

      GBL_DISK_PHYS_WRITE_RATE (SysDiskPhysWriteRate

      Run Queue – not valid for VMWare Guests

      GBL_RUN_QUEUE (SYSPROCRUNQUEUELENGTH) (everything except HP-UX)

      GBL_PRI_QUEUE (SysProcPriorityQueueLength) (HP-UX only)

      If “Is Virtual” = Yes and “Virtualization Technology” = VMWare, use VmGuestCpuPhysPctReady

      Paging Rates (Windows)

      GBL_MEM_PAGEIN_RATE (SYSMEMPAGESINRATE)

      GBL_MEM_PAGEOUT_RATE (SYSMEMPAGESOUTRATE)

      Paging Rate metrics must be on separate axes in the graph.

      Network Packet Rates –

      GBL_NET_IN_PACKET_RATE (SYSNWLFPACKETINRATE)

      GBL_NET_OUT_PACKET_RATE (SYSNWLFPACKETOUTRATE)

      Page Scan Rate

      HP-UX, AIX and Solaris = GBL_MEM_PG_SCAN_RATE (SYSMEMPAGESCANRATE)

      Swap In / Swap Out Byte Rate

       

      *X systems only:  SysMemSwapInByteRate

       

      * X systems only: SysMemSwapOutByteRate

       

       

      ,

       

       

      CPU Total Processor Usage – Forecast vs Actual

      D1_GBL_CPU_TOTAL_USED (SysCpusUsed).  (monthly average, monthly peak hour, monthly peak interval) not really staked bar, but 3 separate bars overlaid

           Trend – Trend line based on 12 month linear trend calculation.  From the last month we have data trend out the next 12 months

            Installed Capacity CI_SYS_PROP_D.NR_OF_PHYSCL_CPU_DN (Installed Capacity comes from ESL)

            Usable Capacity CI_SYS_PROP_D.NR_OF_PHYSCL_CPU_DN * Warning threshold for (Capacity/CPU Percent Used) (Based on warning threshold in ESL)

      Memory Usage

      GBL_MEM_UTIL (SysMemPhysPctUsed) (monthly average, monthly peak hour, Monthly peak interval) not really staked bar, but 3 separate bars overlaid.

      AIX Linux HPUX (GBL_MEM_SYS_UTIL + GBL_MEM_USER_UTIL)

      Usable capacity – Warning threshold  - Capacity – (Physical Memory Percent Used) (D1_GBL_MEM_PHYS_USED)

      Memory Usage Forecast

      D1_GBL_MEM_PHYS_USED (SysMemPhysSpaceUsed) - (monthly average, monthly peak hour, monthly peak interval) not really staked bar, but 3 separate bars overlaid

         Trend – Trend line based on 12 month linear trend calculation.  From the last month we have data trend out the next 12 months

         Installed capacity CI_SYS_PROPR_D.INSTLD_MEM_DN (from ESL)

          Usable Capacity CI_SYS_PROPR_D.INSTLD_MEM_DN * Warning threshold (Capacity - Physical Memory Percent Used)

      Paging Usage

         Windows: GBL_MEM_PAGEOUT_RATE (SysMemPagesOutRate) (monthly average, monthly peak hour, Monthly peak interval) not really staked bar, but 3 separate bars overlaid.

          Solaris – show Page Scan Rate – SysMemPageScanRate

           *X - D1_GBL_MEM_SWAP_RATE (derived metric)

      IO Usage

        GBL_DISK_PHYS_IO_RATE (SysDiskPhysIoRate) (monthly average, monthly peak hour, Monthly peak interval) not really staked bar, but 3 separate bars overlaid.

      Swap Space

         GBL_SWAP_SPACE_UTIL (SysMemSwapPctUsed) (monthly average, monthly peak hour, Monthly peak interval) not really staked bar, but 3 separate bars overlaid.

      If OS = Windows, this graph should be titled“Page File Util”/ all other OSs Title is Swap Space Util