Discussion Board for collaboration on QlikView Scripting.
Go to Solution.
Very smart why. Thank it work.now.
My QV Doc
I changed the name of your GP% expression to: GP%. In the Background Color attribute of the Sales expression I entered the following nested if:
If(GP% > 0.3,rgb(0,128,0)
,If(GP% < 0.15, RGB(255,255,98), RGB(0,255,0))
This resulted in the following:
Is this what you're looking for?