Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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())))
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())))