2 Replies Latest reply: Feb 24, 2013 6:55 AM by Naveenchellaaraam Dhanabalan RSS

    Achieving conditions dynamically

      I have requirement where i need to achieve expressions dynamically,

       

      HeatMap_Rules_Key

      Condition

      MinValue

      MaxValue

      Color

      1

      <

      0

       

      Red

      2

      >=

      100

       

      Blue

      3

      Between

      50

      100

      Green

      4

      Between

      1

      50

      Orange

       

      This table is a lookup table.

      The values in the table can change (like different range and conditions and colour) but it will always have four rows.

      The table explains what i need to show in heat maps.

      If the value of the cell in a table i am displaying in the report is less than zero, then the cell containing the column should be red,

      If it is between 50 and 100, it needs to be in green.

      I am displaying values from another table in a table chart.

      It looks like

      ID

      Sales

      Product1

      Product2

      Product3

      1

      Region1

      0

      50

       

      2

      Region2

      100

       

       

      3

      Region3

      80

      100

       

      4

      Region5

      25

      50

      250

       

      Is it possible to achieve this in qlikview?