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..

[bharani8]

TY Varun!!

[bharani8]

TY Anil

[Kushal_Chawda]

without changing the script you can do something like below

Go to chart properties->Expression-> click '+' -> In background color put below expression

=Pick(match(GetCurrentField([Aging_DD]),'Aging_Bucket2','Aging_Bucket1'),

Pick(match(Aging_Bucket2,'Aging','Non Aging'),lightred(),lightgreen()),

Color(FieldIndex('Aging_Bucket1',Aging_Bucket1)))

[bharani8]

TY!

[Kushal_Chawda]

I would suggest to go with most elegant method which is Pick(match(...    instead complex if conditions

[bharani8]

Hi Anil - When i add the 2nd Expression.. i see both Aging and Non Aging turning to Green.. Can you please help here?