Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
soniasweety
Contributor III

Colour based on value

Hi all,

I have a straight table  with one measure  that result is like below

1

2

3

4

5

6

7

8

9    like that  I need to give this bg colour   light to dark         how can I give?

Tags (2)
1 Solution

Accepted Solutions

Re: Colour based on value

Check with this

=ARGB((MAX(TOTAL TimeLefttoBreachSLA) - Min(TOTAL TimeLefttoBreachSLA))/255 * TimeLefttoBreachSLA, 255, 0, 0)

22 Replies

Re: Colour based on value

May be like this

ARGB(Expression * 25, 192, 192, 192)

soniasweety
Contributor III

Re: Colour based on value

sorry sunny wrong input

its dimension   I calculated in backend and I am calling that as a dimension.

above not working for dimension

Re: Colour based on value

May be this

ARGB(Dimension* 25, 192, 192, 192)

soniasweety
Contributor III

Re: Colour based on value

tried in measure also its not working

check below

argb.PNG

soniasweety
Contributor III

Re: Colour based on value

still not working

same result which I attached below image for both dim,measure aswell

Re: Colour based on value

This is a color, right? Also, What is the values for Open Date?

Re: Colour based on value

Can you provide small sample for this.

Re: Colour based on value

You can try this expression in your Background Properties of your chart.

soniasweety
Contributor III

Re: Colour based on value

Hi Anand& sunny

PFA.  first sheet    ,time left to breach sla column values should be colored by value   light color to dark.

Community Browser