Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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?

1 Solution

Accepted Solutions
sunny_talwar

Check with this

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

View solution in original post

22 Replies
sunny_talwar

May be like this

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

soniasweety
Master
Master
Author

sorry sunny wrong input

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

above not working for dimension

sunny_talwar

May be this

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

soniasweety
Master
Master
Author

tried in measure also its not working

check below

argb.PNG

soniasweety
Master
Master
Author

still not working

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

sunny_talwar

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

its_anandrjs
Champion III
Champion III

Can you provide small sample for this.

its_anandrjs
Champion III
Champion III

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

soniasweety
Master
Master
Author

Hi Anand& sunny

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