Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Sagithya
Partner
Partner

Conditional Colouring in QlikSense Combo Chart

Hi All,

We have a requirement to show Target and Actual in Combo Chart, Target as Line and Actual as Bar. Line should be in a single color always whereas the Bar should change the color based on a condition. If the Actual is less than the Target, it should be in Red and if it is equal or more than the Target, it should be in Green. Please let me know how this can be implemented in QlikSense as I tried with Master Measure and Color by Expression and it didn't work as expected.

Waiting for replies!!

Regards, Sagithya

 

 

 

 

Labels (1)
1 Solution

Accepted Solutions
fosuzuki
Partner
Partner

Aha! Unfortunately, as far as I know, it is not possible -at least with the properties you were using.

But there is a workaround - check this post.

View solution in original post

4 Replies
fosuzuki
Partner
Partner

It would be easier for us to help you if you could describe better the issue... post the expression, screenshots, some evidences!

Sagithya
Partner
Partner
Author

We want to show a combo chart ( Target as Line & Actual as Bar). The Line chart should be in a single color at all the time whereas the bar color has to change based on the difference between the Target and Actual ( Actual < Target in Red and Actual >= Target in Green)

Sagithya_1-1591778401278.png

Tried the below methods and it din't work:

1. Using the "Color by Expression" in the Combo chart, I tired giving If(GetObjectMeasure()='Target','Orange', If(GetObjectMeasure()='Actual' AND Actual >=Target, 'Green', If(GetObjectMeasure()='Actual' AND Actual < Target, 'Red',)))

2. Tried creating master measure and use "Segement Colors" but the conditional coloring in not getting applied dynamically

fosuzuki
Partner
Partner

Aha! Unfortunately, as far as I know, it is not possible -at least with the properties you were using.

But there is a workaround - check this post.

View solution in original post

Sagithya
Partner
Partner
Author

Thank You F