Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
MVP
MVP

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

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.

Community Browser