topic Pivot Table Cell Color in QlikView

Pivot Table Cell Color

vanderson009 — Mon, 30 Jul 2018 05:36:13 GMT

Hi,

I have below data in pivot table,

I want to change background color of cell based on condition if previous year sales is less than current then cell background is green else red.

Thanks,

Villyee

petter — Mon, 30 Jul 2018 06:13:25 GMT

Go to the properties dialog of the Pivot Chart.
Select the "Expressions" tab.
Click the + icon to the left of the Sum(Sales) expression.
Then select "Background Color" and in the "Definition" add the expression
If( Before(Sum(Sales)) < Sum(Sales) OR ColumnNo()=1 , Green(100),Red(100))
Click OK.

mtucholski — Mon, 30 Jul 2018 06:13:32 GMT

if(before(sum(Sale))<sum(Sale),lightgreen(),lightred())