4 Replies Latest reply: Nov 10, 2017 2:27 AM by Dikitso Tsonope RSS

    Qlik Sense - Advanced Conditional Color Expression

    Dikitso Tsonope

      I need help with an expression for a pie chart.

       

      The chart computes the average based on dimension A however I want the overall color of the chart to be influenced by dimension B. I did some research on a few forums and set analysis and this what I have managed to build up so far, any help on this query will be highly appreciated


      if(Avg(${<DimensionB>}Answer)>3.7,

      rgb(0,128,0),

       

      if(Avg(${<DimensionB>}Answer)<=3.7

      AND Avg(${<DimensionB>}Answer)>3.35,

      rgb(50,205,50),

       

      if(Avg(${<DimensionB>}Answer)<=3.35

      AND Avg(${<DimensionB>}Answer)>3.15,

      rgb(255,165,0),

       

      rgb(255,0,0))))