Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use visual effects sheet with expressionsn in pivot table???

Hi,

I have done a pivot table and i want to compare budget column with real column. If real column is higher, turn the value GREEN, if its the same, ORANGE, if its lower RED.

The problem is that, as i think, it compares it with the total of the budget column and not with the value of region that i want.

I attach the file so you can understand better what i reffer to.

Pealse HELP!!!!!

THANKS!!!!

1 Reply
johnw
Champion III
Champion III

I never use visual cues. Instead, on the expressions tab, click on the + next to Tarifa, click on "text color", and then enter this expression:

if(round(Tarifa,.01)>round(sum([BDG Tarifa]),.01),green()
,if(round(Tarifa,.01)<round(sum([BDG Tarifa]),.01),lightred()
,rgb(248,180,39)))

Works fine.