Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Changing color of pivot table cells based on previous cell comparison

I am new to Qlik and working on my first project as a "learning" experience.  I am using Qlik Sense 3.1.

I attached a pivot table I am working on.  I need to change the cell colors based on a comparison between the current cell value and the

previous cell value.  For example: In the monthly revenue pivot table I attached, I need for October amounts to be black text.  For November, each year's total is < those in October, so all those should be red.  For December, 2013/2014 amount should be red because it is < Novembers total.  December's 2014/2015 and 2015/2016 should be green because they are > the amounts for November same year.  Dec 2016/2017 should be red because it is < November 2016/2017 amount...and on throughout the table. I don't know where to begin to write this expression.  Any help would be greatly appreciated! 

Tags (2)
Community Browser