Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one dimension as below:
Duedays
< 10 days
= 10 days
< 10 days
Now i want to write caliculated dimension for barchart
if Duedays < 10 days then bar should be green
if Duedays = 10 days then bar should be orange
if Duedays < 10 days then bar should be red
Please advice.
Thanks,
durga
Hey,
Write the background color expression in expression value.
see the attached inliune
last value is > 10 days I wrote < 10 days value two times.
Please consider and advice.
Hi,
Click the + option of the Duedays dimension.. Double click the background color.. Write the expression as
=if(Duedays < 10 days,RGB(0,255,0),if(Duedays=10 days,RGB(255,128,0),rgb(255,0,0)))
Hi,
USe DueDays as your dimension
the cilck on + symbol
BackgroundColour
write condition
if(Duedays < 10,green(),if(Duedays >10,Red(),RGB(of ORANGE)))
Regards
Hi Ankitha/Max
I am unable to find the changes in my barchart. What might be the problem?
Thanks,
Durga
Hi Durga,
simple example attached
Regards
Andy
andrew,
Please share screenshot, i am unable to open qvw in office due to security reasons.
I wrote the above conditions in my barchart backgroud color expression but color is not changing for bars.
waiting for reply.
Thanks,
Durga
Hey,
Write the background color expression in expression value.
see the attached inliune
Ok,
chart has DueDays as dimension and Count(DueDays) as the expression, the background colour is set against the expression with the following :
if(DueDays < 10,green(), if(DueDays =10,RGB(225,128,0) ,Red()))
The data loaded was:
DueDate:
Load * Inline
[
DueDays
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
];
And the chart looks like this:
Regards
Andy
Thanks anikta and andrew, it is working.
I am writing this condition for dimension. it is not working for dimension. but working for expression.
Once again thanks.
Please see my another question in recent thread.
Help me in writing expression to indicate bulb and advice.
Durga.