topic Re: Dynamic Color Expression in QlikView

Dynamic Color Expression

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Following is the table in my Data Model which may change this value at any time.

I'm using Bar Chart having multiple bars in which i want to use this range of color.

But i cant do it hardcore.because it may change at any time so i want to use variable.

How can i implement it at Background Expression? How implement it in Varibale?

Color	Value from	Value to
Green	0	5
Amber	6	95
Red	96	100

Expression for Bar Chart are as follow

sum(total_exception)/sum(total_qty)*100

Re: Dynamic Color Expression

rubenmarin — Thu, 31 Mar 2016 19:31:02 GMT

Hi sandy, maybe you can use this background expression:

If([ExpressionName]<=Only({<Color={'Green'}>} [Value to]), Green(),

If([ExpressionName]>=Only({<Color={'Red'}>} [Value from]), Red(), Yellow()))

Or create a variable with that content and this bg expression:

$(VariableName)

Change the Green(), Red(), Yellow() for the RGB() you want, and [ExpressionName] to your current expression name, if the name is also an expression you can use [$(CopyNameExpressionHere)]

Re: Dynamic Color Expression

MarcoWedel — Thu, 31 Mar 2016 23:20:08 GMT

Hi,

maybe one solution using variables for the 2 limits could be:

hope this helps

regards

Marco