Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist 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
Highlighted

Re: Colour based on value

Check with this

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

View solution in original post

22 Replies
Highlighted

Re: Colour based on value

May be like this

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

Highlighted
Specialist III
Specialist 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

Highlighted

Re: Colour based on value

May be this

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

Highlighted
Specialist III
Specialist III

Re: Colour based on value

tried in measure also its not working

check below

argb.PNG

Highlighted
Specialist III
Specialist III

Re: Colour based on value

still not working

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

Highlighted

Re: Colour based on value

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

Highlighted

Re: Colour based on value

Can you provide small sample for this.

Highlighted

Re: Colour based on value

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

Highlighted
Specialist III
Specialist 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.