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

25 Replies
Anil_Babu_Samineni

Like this?

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

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

))

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

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

Anil_Babu_Samineni

Why not?

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

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

))

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

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

techvarun
Specialist II
Specialist II

Check the attached,

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

sample.PNG