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]

May be enable option "Multicolored" in colors tab?

[bharani8]

Hi Anil - That will work... But in my DB... if i click on that "Non Aging" .. i need 3 different Green in the next chart (that appears from my Drill down Dimension) and same way... when i click on "Aging".. 3 different red color should appear in the next view of that..

[Anil_Babu_Samineni]

As i thought, It should this for BG color. PFA

If(GetCurrentField([Aging_DD]) = 'Aging_Bucket1', Green())

[bharani8]

I have used the below in my Background color in Expression.. Still.. 61-90 bucket i dont see it is getting reflected to Yellow

if (Aging_Bucket2 = 'Non Aging' ,RGB(77,167,65),

if(Aging_Bucket2 = 'Aging',RGB(255,0,0),

if (Aging_Bucket1 = '>365' , RGB(255,0,0),

if (Aging_Bucket1 = '181-365', RGB(250,70,70),

if (Aging_Bucket1 = '91-180', RGB(252,115,98),

if (Aging_Bucket = '>90' , RGB(255,0,0),

if (Aging_Bucket1 = '61-90' or Aging_Bucket = '61-90', RGB(255,255,0),

if (Aging_Bucket1 = '31-60' or Aging_Bucket = '31-60', RGB(77,167,65),

if (Aging_Bucket1 = '0-30' or Aging_Bucket = '0-30', RGB(77,200,65))))))))))

[techvarun]

Is Aging_Bucket a valid field? Its not available in your sample app

[bharani8]

You are Right.. Ignore that field... Apologies for the confusion

[bharani8]

My Requirement is simple...

if i click on that "Non Aging" .. i need 3 different Green in the next chart (that appears from my Drill down Dimension) and same way... when i click on "Aging".. 3 different red color should appear in the next view of that..

[Anil_Babu_Samineni]

Have you check my file? Does this not helpful to you?

[bharani8]

No Anil... My requirement is diff..

"Non Aging" should be Green color and "Aging" should be Red color

if i click on that "Non Aging" .. i need 3 different Green in the next chart (that appears from my Drill down Dimension) and same way... when i click on "Aging".. 3 different red color should appear in the next view of that..