Discussion Board for collaboration related to QlikView App Development.
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?
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.
View solution in original post
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
No, sadly all values are between 0 and 255 and are floored, so no decimals.
would you be able to share sample app ?
you can try to put your expression into a variable
cool, problem resolved then