Conditional Colouring in QlikSense Combo Chart

[Sagithya]

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

[fosuzuki]

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

[Sagithya]

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)

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 · Accepted solution]

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.

[Sagithya]

Thank You Fosuzuki !!