topic Changing color of pivot table cells based on previous cell comparison in App Development https://community.qlik.com/t5/App-Development/Changing-color-of-pivot-table-cells-based-on-previous-cell/m-p/1290237#M27206 <HTML><HEAD></HEAD><BODY><P>I am new to Qlik and working on my first project as a "learning" experience.&nbsp; I am using Qlik Sense 3.1.</P><P>I attached a pivot table I am working on.&nbsp; I need to change the cell colors based on a comparison between the current cell value and the</P><P>previous cell value.&nbsp; For example: In the monthly revenue pivot table I attached, I need for October amounts to be black text.&nbsp; For November, each year's total is &lt; those in October, so all those should be red.&nbsp; For December, 2013/2014 amount should be red because it is &lt; Novembers total.&nbsp; December's 2014/2015 and 2015/2016 should be green because they are &gt; the amounts for November same year.&nbsp; Dec 2016/2017 should be red because it is &lt; November 2016/2017 amount...and on throughout the table. I don't know where to begin to write this expression.&nbsp; Any help would be greatly appreciated!&nbsp; </P></BODY></HTML> Fri, 03 Feb 2017 14:13:03 GMT 2017-02-03T14:13:03Z Changing color of pivot table cells based on previous cell comparison https://community.qlik.com/t5/App-Development/Changing-color-of-pivot-table-cells-based-on-previous-cell/m-p/1290237#M27206 <HTML><HEAD></HEAD><BODY><P>I am new to Qlik and working on my first project as a "learning" experience.&nbsp; I am using Qlik Sense 3.1.</P><P>I attached a pivot table I am working on.&nbsp; I need to change the cell colors based on a comparison between the current cell value and the</P><P>previous cell value.&nbsp; For example: In the monthly revenue pivot table I attached, I need for October amounts to be black text.&nbsp; For November, each year's total is &lt; those in October, so all those should be red.&nbsp; For December, 2013/2014 amount should be red because it is &lt; Novembers total.&nbsp; December's 2014/2015 and 2015/2016 should be green because they are &gt; the amounts for November same year.&nbsp; Dec 2016/2017 should be red because it is &lt; November 2016/2017 amount...and on throughout the table. I don't know where to begin to write this expression.&nbsp; Any help would be greatly appreciated!&nbsp; </P></BODY></HTML> Fri, 03 Feb 2017 14:13:03 GMT https://community.qlik.com/t5/App-Development/Changing-color-of-pivot-table-cells-based-on-previous-cell/m-p/1290237#M27206 2017-02-03T14:13:03Z