Gradient color in pivot table

[ks20]

Hi Community, 

I need to have background color expression for my pivot table, where the minimum is the lowest value, midpoint is 50% and maximum is the highest value.

Dimension: week,date
Measure:  sum(A)/sum(B)

Any guidance would be appreciated. Thank you!

[MatheusC]

Olá,  @ks20 

Essa expressão pode te atender, altere conforme sua necessidade,

vídeo explicativo. Espero que ajude!
https://youtu.be/DWoootVjdxs

ColorMix2(

  (

  avg([Total-Venda])

  -

  min(total

Agr(

     avg([Total-Venda])

    ,Filial))    

  -

  (

   Max(total

Agr(

      avg([Total-Venda])

     ,Filial))

    -

    min(total

  Agr(

        avg([Total-Venda])

       ,Filial))

   )    

   /

   2  

   )

  /

  (

  (  

   Max(total

Agr(

      avg([Total-Venda])

     ,Filial))

    -

    min(total

  Agr(

    avg([Total-Venda])

        ,Filial))

   )

   /

   2

   )

,

Vermelho(),

Verde(),

Amarelo()

)

[MatheusC]

@ks20 

If you have solved your question, close the topic with the solution to help the qlik community.

Thanks

[ks20]

Thanks for you response, but the solution din't work in my case.