3 Replies Latest reply: Oct 19, 2017 3:20 PM by Antonio Domingos Neto RSS

    Colormix1 gradient pivot:

    Annamaria Ascione

      Hi,

      I'm working on a qliksense document. I need to color the pivot table according to the measurament: Incidenza Ordini su Totale

      Logics to color: the major in green and the worst in red (with the shades of colour in the centre).

      Now i used :ColorMix1( rank(total column(1))/noofrows(TOTAL) , lightred(),LightGreen())

      But is not correct to my Logics to color: the major in green and the worst in red (with the shades of colour in the centre).

       

      I attach the qliksense app and the picture of what I want to replicate with qliksense.