
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Qlik Table chart, color by values
Hi guys,
i am using vizlib in Qlik sense, i created a table, but i would like to color by values the cell, like i did it in tableau (picture attached)
the greater the value --> the darker color ie. to use gradient
pls help asap
Ena
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello @ena1309
You can use the colormix function. Just replace the color ARGB values and the aggregation formule -> sum(Value)
ARGB (255, 0, 64, 128) is the darkest color.
=ColorMix1 ((1+Sign(2*(sum(Value)-RangeMin (top(total sum(Value),1,NoOfRows(total))))/(RangeMax (top(total sum(Value),1,NoOfRows(total)))-RangeMin (top(total sum(Value),1,NoOfRows(total))))-1)*Sqrt(Fabs((2*(sum(Value)-RangeMin (top(total sum(Value),1,NoOfRows(total))))/(RangeMax (top(total sum(Value),1,NoOfRows(total)))-RangeMin (top(total sum(Value),1,NoOfRows(total))))-1))))/2, ARGB(255, 128, 255, 255), ARGB(255, 0, 64, 128))
Kind regards
Eddie
If this answers your question or solves your issue, be sure to mark the answer as correct by clicking 'Accept as Solution'. This will mark the post as solved and other Qlikkies will gravitate towards this post as it as a possible solution for their issue. Multiple responses can be accepted as a solution so make sure to select all that apply. |

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
=colormix1(sum([YOUR VALUE])/484,RGB(118,183,178),RGB(78,121,167)))
Instead of '484, which represent max value or ceiling, you can try to aggregate your max value from table for better result if your values are constantly changing.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It won't work 😞
my values are from measured field: Count(distinct[Coil_Batch_Number])
i tried this colormix1((Count(distinct[Coil_Batch_Number]))/484,RGB(118,183,178),RGB(78,121,167))))
what to do ?
thx again !

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello @ena1309
You can use the colormix function. Just replace the color ARGB values and the aggregation formule -> sum(Value)
ARGB (255, 0, 64, 128) is the darkest color.
=ColorMix1 ((1+Sign(2*(sum(Value)-RangeMin (top(total sum(Value),1,NoOfRows(total))))/(RangeMax (top(total sum(Value),1,NoOfRows(total)))-RangeMin (top(total sum(Value),1,NoOfRows(total))))-1)*Sqrt(Fabs((2*(sum(Value)-RangeMin (top(total sum(Value),1,NoOfRows(total))))/(RangeMax (top(total sum(Value),1,NoOfRows(total)))-RangeMin (top(total sum(Value),1,NoOfRows(total))))-1))))/2, ARGB(255, 128, 255, 255), ARGB(255, 0, 64, 128))
Kind regards
Eddie
If this answers your question or solves your issue, be sure to mark the answer as correct by clicking 'Accept as Solution'. This will mark the post as solved and other Qlikkies will gravitate towards this post as it as a possible solution for their issue. Multiple responses can be accepted as a solution so make sure to select all that apply. |

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try to put this one more thime
colormix1(Count(distinct[Coil_Batch_Number])/484,RGB(118,183,178),RGB(78,121,167))
into 'Background color expression' field of your measure
