Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Changing color of Pivot Table cell based on Expression

Hi all,

I have a Pivot Table that sums sales for each product during the last full 365 days.

My Dimensions are:

Product Class  (like toys, shirts, pants)

Product Name (like race car, tanktop, grungy jeans)

CalendarMonthYear May-2013, June-2013 .. . .  Apr - 2014)

My Expression is:

SUM({<Product_ProductName = >}Order_Counter)

What I want to do is change the background color of each sell to red if this months sales are lower than last months sales and green if the are greater.

Thank you all for looking and your help.

0 Replies