Background Color for a Calculated Dimension in a Bar Chart

JoaquinLavin — Fri, 20 Jan 2023 19:45:16 GMT

Hello everyone,

I have a Bar Chart using a single calculated dimension:

round(([Overall Goals Rating] + [Overall VBBs Rating])/2,0.1)

I need to have a different color for the bar that shows a "3,0" result.

Currently I'm using this expression:

=count(DISTINCT{<Period={'01.12.2022'}, RL-={'2A','3','4A','4B','7'}, [Planning period]={'2022/2023'}>}[System ID])

And this definition in Background Color:

=if((round(([Overall Goals Rating] + [Overall VBBs Rating])/2,0.1))=3,rgb(255,217,47))

But the Background Color isn't working. If I move the RGB function to the "false value" (or "then" in the IF function), all the bars change to that color.

What I take from this is that the "... = 3" condition is never being read as TRUE.

How can I make this work? Thanks

Re: Background Color for a Calculated Dimension in a Bar Chart

rubenmarin — Sun, 22 Jan 2023 07:48:11 GMT

Hi, I tested and it works for me.

Check that all fields exists and that the 3.0 bar has data.

If still doesn't works you can upload a sample that demonstrates the issue to check if there is another thing preventing to color the bar.

topic Re: Background Color for a Calculated Dimension in a Bar Chart in QlikView

Background Color for a Calculated Dimension in a Bar Chart

Re: Background Color for a Calculated Dimension in a Bar Chart