Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with Visual Cues (conditional format)

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

2 Replies
danielrozental
Master II
Master II

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

Not applicable
Author

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.