Expression background color

[bharani8]

Hi Experts - In the attached qvw... i have an Drill down as Dimension...

In the chart... For the "Aging" the bar should appear as Red color and for "Non Aging" Bar color should be Green..

While we click on "Aging" (as it is Drill down), i need the next 3 bars in 3 different color (any color) ...

and same logic while clicking on "Non Aging" as well..

I tried with If condition .. but not coming as expected.. Plz Help..

[Anil_Babu_Samineni]

Like this?

Note : Please mark it as helpful and that link up to helpers...

[Anil_Babu_Samineni]

I used this, If you don't have license

If(Match(Aging_Bucket2, 'Aging') and GetCurrentField([Aging_DD]) = 'Aging_Bucket1',  Green(),

If(Match(Aging_Bucket2, 'Non Aging') and GetCurrentField([Aging_DD]) = 'Aging_Bucket1',  Red(),

))

[bharani8]

But Aging and Non Agng Bars i see in Blue itself...cant we change that to Red and Green?

[Anil_Babu_Samineni]

Why not?

[bharani8]

Perfect... Now in that "61-90" bucket alone i need to be in yellow.. Is that possible ? Rest all should be same..

[Anil_Babu_Samineni]

You can write if(..else....elseif...)

If(Match(Aging_Bucket2, 'Aging') and GetCurrentField([Aging_DD]) = 'Aging_Bucket1',  Green(),

If(Match(Aging_Bucket2, 'Non Aging') and GetCurrentField([Aging_DD]) = 'Aging_Bucket1',  Red(), Yellow()

))

[bharani8]

Not Working... Now i see Aging and Non Aging Bars in Yellow

[techvarun]

Check the attached,

[Anil_Babu_Samineni · Accepted solution]

My Bad? PFA..

[techvarun]