0 Replies Latest reply: Feb 3, 2017 9:13 AM by Karen Lashley RSS

    Changing color of pivot table cells based on previous cell comparison

    Karen Lashley

      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!