Color change for bar graph

[#1]

Hi All,

I have attached the screen shots because i cannot copy the QVW file.

Dimension : =if(IsNum([Turnaround Time Network Days]), IF([Turnaround Time Network Days]>15, '16 + ', [Turnaround Time Network Days]),'Missing Dates')

Fact : Count([Turnaround Time RAG])

Colors of the bars should be GREEN AMBER and RED based on condition.

Condition : if ([Turnaround Time Network Days])>7, Red()

                     if ([Turnaround Time Network Days])<=3, Green()

                     if ([Turnaround Time Network Days])<=7, Amber()

I got the colors but the problem is if [Turnaround Time Network Days]>15 i have grouped into '16+' i want this bar to be in RED(). I am not able to do it. Please help me with this.

Check the screen shots.

Thanks & Regards,

Keerthi

[#2]

Ok then modify the expression as follows:

if ([Turnaround Time Network Days])<=3, Green(),

if ([Turnaround Time Network Days])<=7, Amber(),

if ([Turnaround Time Network Days])>7,Red(),Black())))

[#3]

I gave the same expression but '16+' is coming in Black

[#4]

16+ should be in RED.

[#5]

Please provide me the expression.

[#6]

I got the issue, it is because '16+' behaves as string while except missing dates all are numeric values. So further little modification required.

if ([Turnaround Time Network Days]<=3, Green(),

if ([Turnaround Time Network Days]<=7, Amber(),

if ([Turnaround Time Network Days]>7 or [Turnaround Time Network Days]='16+',Red(),Black())))

Hope this works.

[#7]

Still 16+ is coming in black

[#8]

if (num([Turnaround Time Network Days])<=3, Green(),

if (num([Turnaround Time Network Days])<=7, Amber(),

if (num([Turnaround Time Network Days])>7,Red(),Black())))

[MayilVahanan]

Hi

Create the dimension based on this expression in script and then use that field as dimension in bar chart.

ex:

Load

if(IsNum([Turnaround Time Network Days]), IF([Turnaround Time Network Days]>15, '16 + ', [Turnaround Time Network Days]),'Missing Dates') AS TurnAround,

*

From tablename;

Then use TurnAround as Dimension.

We can apply color for that dimension.

[#10]

Sorry again 16+ in Black

[sunilkumarqv]

Try this

Expression -> click the '+' sign -> background color

IF([Turnaround Time Network Days] < 3, Green(),

if([Turnaround Time Network Days] < 7, Yellow(),  // instead of yellow, use RGB for amber

if([Turnaround Time Network Days] ='16+', red())))