3 Replies Latest reply: Nov 30, 2017 1:14 PM by Robin Hausdörfer RSS

    Looking for calculated dimension expression

    Bharath Vikas Shanagonda

      Hi,

       

      I've a column like below in my Qlikview.

       

         

      RISK_SCORE
      0
      1
      2
      3
      4
      5
      6
      7
      8

       

       

      I'm looking for a calculate dimension expression in pivot table when Risk_Score>0 and Risk_Score<=3 it needs to be 'LOW', if Risk_Score>3 and Risk_Score<=6 it needs to be 'MEDIUM' and when Risk_Score>6 needs to be 'HIGH'.

       

      Regards,

      Vikas

       

      Message was edited by: Bharath Vikas Shanagonda