Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bharani8
Creator III
Creator III

Expression background color

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

1 Solution

Accepted Solutions
Anil_Babu_Samineni

My Bad? PFA..

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

25 Replies
Anil_Babu_Samineni

May be enable option "Multicolored" in colors tab?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
bharani8
Creator III
Creator III
Author

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())

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
bharani8
Creator III
Creator III
Author

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
Specialist II
Specialist II

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

bharani8
Creator III
Creator III
Author

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

bharani8
Creator III
Creator III
Author

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?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
bharani8
Creator III
Creator III
Author

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