topic Date Range_color code in QlikView

topic Date Range_color code in QlikView https://community.qlik.com/t5/QlikView/Date-Range-color-code/m-p/1881155#M1216852 <P>Hi </P> <P>date range for color code</P> <P>sample data:</P> <TABLE width="768"> <TBODY> <TR> <TD width="64">study</TD> <TD width="64">start_date</TD> <TD width="64">end_date</TD> <TD width="64">date_range</TD> <TD width="64">blue</TD> <TD width="128">grey</TD> <TD width="128">original</TD> <TD width="128">new</TD> <TD width="64">tracking</TD> </TR> <TR> <TD>M6944</TD> <TD colspan="2">2021-08-03</TD> <TD> </TD> <TD>2021-09-27</TD> <TD>2021-10-15 00:00:00</TD> <TD>2022-10-14 00:00:00</TD> <TD>2023-06-26 00:00:00</TD> <TD>Y</TD> </TR> <TR> <TD>M6944</TD> <TD colspan="2">2021-08-03</TD> <TD> </TD> <TD>2021-08-24</TD> <TD>2021-08-21 00:00:00</TD> <TD>2022-07-23 00:00:00</TD> <TD>2022-04-09 00:00:00</TD> <TD>Y</TD> </TR> <TR> <TD>M6944</TD> <TD colspan="2">2021-08-03</TD> <TD> </TD> <TD> </TD> <TD>2022-01-15 00:00:00</TD> <TD>2022-04-09 00:00:00</TD> <TD>2022-04-09 00:00:00</TD> <TD>N</TD> </TR> <TR> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD> </TD> <TD colspan="3">end_date=max(original,new)</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> </TBODY> </TABLE> <P> </P> <P>1. if original > new then from original to new display pink color, if original <new then display green.</P> <P>2. if tracking=y from blue color date to end date display blue color</P> <P>please help me for the expression.</P> <P>i have generated dates.</P> Fri, 14 Jan 2022 13:36:54 GMT nvijay5757 2022-01-14T13:36:54Z Date Range_color code https://community.qlik.com/t5/QlikView/Date-Range-color-code/m-p/1881155#M1216852 <P>Hi </P> <P>date range for color code</P> <P>sample data:</P> <TABLE width="768"> <TBODY> <TR> <TD width="64">study</TD> <TD width="64">start_date</TD> <TD width="64">end_date</TD> <TD width="64">date_range</TD> <TD width="64">blue</TD> <TD width="128">grey</TD> <TD width="128">original</TD> <TD width="128">new</TD> <TD width="64">tracking</TD> </TR> <TR> <TD>M6944</TD> <TD colspan="2">2021-08-03</TD> <TD> </TD> <TD>2021-09-27</TD> <TD>2021-10-15 00:00:00</TD> <TD>2022-10-14 00:00:00</TD> <TD>2023-06-26 00:00:00</TD> <TD>Y</TD> </TR> <TR> <TD>M6944</TD> <TD colspan="2">2021-08-03</TD> <TD> </TD> <TD>2021-08-24</TD> <TD>2021-08-21 00:00:00</TD> <TD>2022-07-23 00:00:00</TD> <TD>2022-04-09 00:00:00</TD> <TD>Y</TD> </TR> <TR> <TD>M6944</TD> <TD colspan="2">2021-08-03</TD> <TD> </TD> <TD> </TD> <TD>2022-01-15 00:00:00</TD> <TD>2022-04-09 00:00:00</TD> <TD>2022-04-09 00:00:00</TD> <TD>N</TD> </TR> <TR> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD> </TD> <TD colspan="3">end_date=max(original,new)</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> </TBODY> </TABLE> <P> </P> <P>1. if original > new then from original to new display pink color, if original <new then display green.</P> <P>2. if tracking=y from blue color date to end date display blue color</P> <P>please help me for the expression.</P> <P>i have generated dates.</P> Fri, 14 Jan 2022 13:36:54 GMT https://community.qlik.com/t5/QlikView/Date-Range-color-code/m-p/1881155#M1216852 nvijay5757 2022-01-14T13:36:54Z