https://community.qlik.com/t5/QlikView/Cell-coloring-based-on-previous-row-values/m-p/1700521#M724341 <P>Can someone please help me here.</P> Sun, 10 May 2020 23:23:58 GMT sayadutt 2020-05-10T23:23:58Z https://community.qlik.com/t5/QlikView/Cell-coloring-based-on-previous-row-values/m-p/1700288#M724340 <P>Hi Team,</P><P>My requirement is to color the below pivot table cells based on the values from its previous day. If the value is less than previous day mark it as Red, if its greater than previous value then make it Green.</P><P>Like below:</P><TABLE width="323"><TBODY><TR><TD width="127">Team</TD><TD width="98">5/7/20</TD><TD width="98">5/8/20</TD></TR><TR><TD>A</TD><TD>100.00</TD><TD>100.00</TD></TR><TR><TD>B</TD><TD>92.59</TD><TD><STRONG><FONT color="#339966">96.30</FONT></STRONG></TD></TR><TR><TD>C</TD><TD>100.00</TD><TD><FONT color="#FF0000"><STRONG>92.00</STRONG></FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>My data is getting loaded from sharepoint and looks like this:</P><TABLE width="273"><TBODY><TR><TD width="77">Team</TD><TD width="98">Date</TD><TD width="98">Value</TD></TR><TR><TD>A</TD><TD>5/7/20</TD><TD>100.00</TD></TR><TR><TD>B</TD><TD>5/7/20</TD><TD>92.59</TD></TR><TR><TD>C</TD><TD>5/7/20</TD><TD>100.00</TD></TR><TR><TD>A</TD><TD>5/8/20</TD><TD>100.00</TD></TR><TR><TD>B</TD><TD>5/8/20</TD><TD>96.30</TD></TR><TR><TD>C</TD><TD>5/8/20</TD><TD>92.00</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Please note that I can't modify at Load script level due to some other factors.</P><P>&nbsp;</P><P>&nbsp;</P><P>Thanks</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Cell-coloring-based-on-previous-row-values/m-p/1700288#M724340 sayadutt 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Cell-coloring-based-on-previous-row-values/m-p/1700521#M724341 <P>Can someone please help me here.</P> Sun, 10 May 2020 23:23:58 GMT https://community.qlik.com/t5/QlikView/Cell-coloring-based-on-previous-row-values/m-p/1700521#M724341 sayadutt 2020-05-10T23:23:58Z