topic Formatting Pivot table cell background in QlikView

Formatting Pivot table cell background

Mon, 18 Aug 2014 06:52:38 GMT

Hi,

Is there a way to chnage the cell background based on the value of precious cell.

For Eg: If cell1 > cell2 then green() else Red().

I have used background colour expressions based on the dimension values and cell value thresholds, but not by comparing two cells.

Please let me know if anybody has tried this already.

Thanks,

Shruthi Reddy

tresB — Mon, 18 Aug 2014 07:22:27 GMT

May be like:

If( Before(Sum(Sales))> Sum(Sales), green(), Red())

Mon, 18 Aug 2014 07:25:37 GMT

Yes, I got it working.

If the dimension is shown vertical then If( Above(Sum(Sales))> Sum(Sales), green(), Red())

If the dimension is shown horizontal If( Before(Sum(Sales))> Sum(Sales), green(), Red())