11 Replies Latest reply: Aug 6, 2015 2:32 AM by kushal chawda RSS

    If Statement/Set Analysis

    Cassandra Baqir

      I currently use the following expression to display red/yellow/green/gray symbols for a health chart:


      =if([SUB_OVERALL_HEALTH] = 'Green' , 'qmem://<bundled>/BuiltIn/check_g.png'

      if([SUB_OVERALL_HEALTH] = 'Yellow' , 'qmem://<bundled>/BuiltIn/exclamation_y.png'

      if([SUB_OVERALL_HEALTH] = 'Red' , 'qmem://<bundled>/BuiltIn/cross_r.png'

      , 'qmem://<bundled>/BuiltIn/minus.png'


      I need to include some filters so that certain rows of data are not displayed. For example, I only want to see info for a REQUEST_ID that meets the following conditions:


      1. REQ_STATUS = 'Open'

      2. DISPLAY_STATUS <> 'Close Out'

      3. REQ_TYPE <> Minor Project, Ops and Maint or Admin


      How do I incorporate this (I figured it would be set analysis) into the chart so I only see data for REQUEST_IDs that meet those conditions?