Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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..

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

25 Replies
Anil_Babu_Samineni

May be enable option "Multicolored" in colors tab?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
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())

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
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?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
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..