topic Help with Visual Cues (conditional format) in QlikView

Help with Visual Cues (conditional format)

Fri, 22 Jul 2011 20:22:09 GMT

I have a pivot table with 3 columns: Expression A (2010Sales), Expression B(2011Sales), and Expression C(YoY%). I want to conditionally format the column for Expression C...but only where the value of Expression B is > 10,000. I can't figure out how to accomplish this. Is it possible?

Thanks, Dan

Help with Visual Cues (conditional format)

danielrozental — Fri, 22 Jul 2011 20:42:27 GMT

Sure, change the background color in the 3rd expression to something like if(column(2)>10000, red(), green())

Help with Visual Cues (conditional format)

Fri, 22 Jul 2011 21:03:05 GMT

Thanks, Daniel. That worked, except I probably should've mentioned that I want to conditionally format Expression C as you've described, but only when the value in Expression C is +/- 10%. In other words, highlight the value in Expression C when it is +/- 10% AND the value of Expression B is > 10,000. Any suggestions?

Thanks again.