Hello I need create an expression that displays data in colors that change according to it's values, for exemple red if it's negative and green if it's positive, I have created the expression and added the condition in the background color section of the expression but it doesn't seem to work, QlikView forces the default colors. what should i do. the condition is
I think you may have put the formula about the colour in the wrong place... Is it under the expression itself in the background subsection (where it should be)? Or in the colour pallete, or somewhere else?
Are you using grid chart or scatter chart? If scatter - make sure the colour formula is set for the 1st expression, the one that appears on the x-axis.