0 Replies Latest reply: Oct 19, 2018 12:54 PM by David McLachlan RSS

    Table Colour Ramp produces odd sorting behaviour

    David McLachlan

      Hi there,

       

      I'm attempting to create somewhat simple colour ramps in a table column to improve presentation of data.

       

      My thought process was to use Colormix1 and use the row number of the table to interpolate between two RGB() values.

       

      My background expression is as follows

       

      Colormix1(rowno(TOTAL)*(1/noofrows()),RGB(32,190,219),RGB(5,67,117))

       

      This provides a number between 0 and 1 to allow a colour ramp between the two RGB() sets. The problem am facing is that the column sorting no longer seems works, as you can see below! Very frustrating. Any ideas?


      Best,

      David

      QlikSorting_withColourRamp.PNG