Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
davidmlachlan
Contributor II
Contributor II

Table Colour Ramp produces odd sorting behaviour

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

0 Replies