Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
JJ141
Contributor II
Contributor II

Colour Gradient For Table Column

Hi all,

I am looking for a way to colour each column with the smallest number having the lightest number and the largest number having the darkest colour.

The expression I have tried is:

 

ColorMix1(
rank( total(
<expression for the column>
)
)
, $(vColorMixLight), $(vColorMixDark))

which gives me the attached result.

 

Any help would be greatly appreciated. 🙂

 

Labels (3)
1 Reply
Cybb9870
Contributor II
Contributor II

colormix1 function 's first part should between 0~1, your rank function's result will start from 1; I think that's why only 1 color is showed on the screen, maybe you can consider to change it~