topic Re: Conditional colors for intervals? in QlikView

Conditional colors for intervals?

CanOls — Sat, 16 Nov 2024 20:04:44 GMT

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

Surya — Mon, 16 Sep 2019 09:31:56 GMT

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())))