1 Reply Latest reply: Apr 5, 2018 3:30 PM by Antonio Domingos RSS

    Help with Colormix or another function

    Antonio Domingos

      Hey Guys!!

       

      I have a table with a lot of lines. I would like to format the values following one rule.

       

      For example:

      The higher value will be red, intermediate yellow and lower green, making a gradient through the other valus of the line.

       

      My expression to format

       

      (SUM(RISCO_C_11_14)+SUM(RISCO_D_15_30))

      /

      before(sum({1}RISCO_A_EM_DIA))


      It's killing me lol.

       

      Thank you guys!!

        • Re: Help with Colormix or another function
          Antonio Domingos

          I tried using ColorMix Wizard in qlikview.

           

           

          ColorMix1 ((1+Sign(2*((SUM(RISCO_C_11_14)+SUM(RISCO_D_15_30))

          /

          before(sum({1}RISCO_A_EM_DIA)) -RangeMin (top(total (SUM(RISCO_C_11_14)+SUM(RISCO_D_15_30))

          /

          before(sum({1}RISCO_A_EM_DIA)) ,1,NoOfRows(total))))/(RangeMax (top(total (SUM(RISCO_C_11_14)+SUM(RISCO_D_15_30))

          /

          before(sum({1}RISCO_A_EM_DIA)) ,1,NoOfRows(total)))-RangeMin (top(total (SUM(RISCO_C_11_14)+SUM(RISCO_D_15_30))

          /

          before(sum({1}RISCO_A_EM_DIA)) ,1,NoOfRows(total))))-1)*Sqrt(Fabs((2*((SUM(RISCO_C_11_14)+SUM(RISCO_D_15_30))

          /

          before(sum({1}RISCO_A_EM_DIA)) -RangeMin (top(total (SUM(RISCO_C_11_14)+SUM(RISCO_D_15_30))

          /

          before(sum({1}RISCO_A_EM_DIA)) ,1,NoOfRows(total))))/(RangeMax (top(total (SUM(RISCO_C_11_14)+SUM(RISCO_D_15_30))

          /

          before(sum({1}RISCO_A_EM_DIA)) ,1,NoOfRows(total)))-RangeMin (top(total (SUM(RISCO_C_11_14)+SUM(RISCO_D_15_30))

          /

          before(sum({1}RISCO_A_EM_DIA)) ,1,NoOfRows(total))))-1))))/2, RGB(255, 34, 0), RGB(0, 255, 17))

           

          The expression is "OK" but isn't working.

           

          Why?

           

          Tks!