Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
harveenkaur
Contributor III
Contributor III

Color in pivot table

Hi

I want to color the fields in pivot table as shown in sample data below.(Red indicates the area where  growth of city is less comparative to country growth and green in vice versa case. Growth has been calculated as CY/LY-1

growth.PNG

 

1 Reply
hopkinsc
Partner
Partner

Hi

You just need an IF() statement on the background colour of the expression.

IF(CY<LY-1,Red(),Green())