topic Re: Dynamic RGB Code in QlikView

Dynamic RGB Code

max_potass — Fri, 13 Jul 2018 14:15:20 GMT

Hi everyone,

I want to create a dynamic Bacground color in a chart. I thought following would work:

RGB(Floor((1-(KAM/Max(All KAM)))*255),Floor((KAM/Max(All KAM))*255),0)

KAM is an integer.

I also checked, if the single expression work. They do. So I get RGB(0,255,0). But if I use it in the chart, I get an Error:

"Drawing of Chart failed internally"

Is what I am trying to do even possible, or do I have a mistake?

Best Regards

Max

YoussefBelloum — Fri, 13 Jul 2018 14:31:45 GMT

EDITED

Hi,

did you take a look at the values you get with this: (1-(KAM/Max(All KAM)))*255

maybe you go out of the range of 3 digits and exceed 255

max_potass — Mon, 16 Jul 2018 14:12:11 GMT

No, sadly all values are between 0 and 255 and are floored, so no decimals.

YoussefBelloum — Mon, 16 Jul 2018 14:15:22 GMT

would you be able to share sample app ?

you can try to put your expression into a variable

max_potass — Mon, 16 Jul 2018 15:04:43 GMT

Well, I just did the file and it works there. I have the exact same field names and Expressions.

But I found the problem.

I had to define a color for the other Expression in the chart. I have no Idea why... But that fixed it.

Thanks.

YoussefBelloum — Mon, 16 Jul 2018 15:09:00 GMT

cool, problem resolved then