Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
CanOls
Contributor III
Contributor III

Conditional colors for intervals?

Hi Qlik Community

I have a bar chart that I'd like to add conditional colors to. 

The x-axis is days and the y-axis is number of invoices. 

I'd like to add colors to the bars depending on how long the invoices has been untouched. 

Something like, 1-20 days = Green, 21-50 = Blue, 51-75 = Orange and 76 < = Red.

Any help is appreciated.

Casper

Labels (4)
1 Solution

Accepted Solutions
Surya
Creator II
Creator II

Hello,

 

1-20 days = Green, 21-50 = Blue, 51-75 = Orange and 76 < = Red.

goto u r field expand and  wrtten this code

if(fieldname >=1 and fieldname <= 20 ,QlikviwGreen(),

if(fieldname >=21 and fieldname <= 50 ,Qlikviwblue(),

if(fieldname >=51 and fieldname <= 75 ,rgb(123,123,454),

if(fieldname <=75,Red())))

 

View solution in original post

1 Reply
Surya
Creator II
Creator II

Hello,

 

1-20 days = Green, 21-50 = Blue, 51-75 = Orange and 76 < = Red.

goto u r field expand and  wrtten this code

if(fieldname >=1 and fieldname <= 20 ,QlikviwGreen(),

if(fieldname >=21 and fieldname <= 50 ,Qlikviwblue(),

if(fieldname >=51 and fieldname <= 75 ,rgb(123,123,454),

if(fieldname <=75,Red())))