topic Where with this condition in QlikView

topic Where with this condition in QlikView https://community.qlik.com/t5/QlikView/Where-with-this-condition/m-p/1912609#M1218230 <P>Hi, I have the following table:</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="25%" height="25px">DATE</TD> <TD width="25%" height="25px">STAGE</TD> <TD width="25%" height="25px">DEPARTURE DATE</TD> <TD width="25%" height="25px">NEWSTAGE</TD> </TR> <TR> <TD width="25%" height="25px">03/02/2022 12:04:29</TD> <TD width="25%" height="25px">1. Process</TD> <TD width="25%" height="25px">03/02/2022</TD> <TD width="25%" height="25px"> </TD> </TR> <TR> <TD width="25%" height="28px">03/02/2022 13:17:24</TD> <TD width="25%" height="28px">1. Process</TD> <TD width="25%" height="28px">03/02/2022</TD> <TD width="25%" height="28px"> </TD> </TR> <TR> <TD width="25%" height="25px">03/02/2022 13:20:00</TD> <TD width="25%" height="25px">1. Process</TD> <TD width="25%" height="25px">03/02/2022</TD> <TD width="25%" height="25px"> </TD> </TR> <TR> <TD height="25px">03/02/2022  13:25:00</TD> <TD height="25px">-------</TD> <TD height="25px"> </TD> <TD height="25px">1.4 Process</TD> </TR> <TR> <TD height="25px">03/02/2022  13:27:00</TD> <TD height="25px">1. Process</TD> <TD height="25px"> </TD> <TD height="25px"> </TD> </TR> </TBODY> </TABLE> <P> </P> <P>And I would like to do a where so that it looks like this:</P> <P> </P> <TABLE border="1"> <TBODY> <TR> <TD width="147.828px" height="25px">DATE</TD> <TD width="147px" height="25px">STAGE</TD> <TD width="147px" height="25px">DEPARTURE DATE</TD> <TD width="147px" height="25px">NEWSTAGE</TD> </TR> <TR> <TD width="147.828px" height="25px">03/02/2022 12:04:29</TD> <TD width="147px" height="25px">1. Process</TD> <TD width="147px" height="25px">03/02/2022</TD> <TD width="147px" height="25px"> </TD> </TR> <TR> <TD width="147.828px" height="28px">03/02/2022 13:17:24</TD> <TD width="147px" height="28px">1. Process</TD> <TD width="147px" height="28px">03/02/2022</TD> <TD width="147px" height="28px"> </TD> </TR> <TR> <TD width="147.828px" height="25px">03/02/2022 13:20:00</TD> <TD width="147px" height="25px">1. Process</TD> <TD width="147px" height="25px">03/02/2022</TD> <TD width="147px" height="25px"> </TD> </TR> <TR> <TD width="147.828px" height="25px">03/02/2022  13:25:00</TD> <TD width="147px" height="25px">-------</TD> <TD width="147px" height="25px"> </TD> <TD width="147px" height="25px">1.4 Process</TD> </TR> </TBODY> </TABLE> <P> </P> <P>Every time a 1.4 Process stage is found, it keeps the previous information</P> <P> </P> Thu, 31 Mar 2022 15:08:17 GMT Aldemarprins4 2022-03-31T15:08:17Z Where with this condition https://community.qlik.com/t5/QlikView/Where-with-this-condition/m-p/1912609#M1218230 <P>Hi, I have the following table:</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="25%" height="25px">DATE</TD> <TD width="25%" height="25px">STAGE</TD> <TD width="25%" height="25px">DEPARTURE DATE</TD> <TD width="25%" height="25px">NEWSTAGE</TD> </TR> <TR> <TD width="25%" height="25px">03/02/2022 12:04:29</TD> <TD width="25%" height="25px">1. Process</TD> <TD width="25%" height="25px">03/02/2022</TD> <TD width="25%" height="25px"> </TD> </TR> <TR> <TD width="25%" height="28px">03/02/2022 13:17:24</TD> <TD width="25%" height="28px">1. Process</TD> <TD width="25%" height="28px">03/02/2022</TD> <TD width="25%" height="28px"> </TD> </TR> <TR> <TD width="25%" height="25px">03/02/2022 13:20:00</TD> <TD width="25%" height="25px">1. Process</TD> <TD width="25%" height="25px">03/02/2022</TD> <TD width="25%" height="25px"> </TD> </TR> <TR> <TD height="25px">03/02/2022  13:25:00</TD> <TD height="25px">-------</TD> <TD height="25px"> </TD> <TD height="25px">1.4 Process</TD> </TR> <TR> <TD height="25px">03/02/2022  13:27:00</TD> <TD height="25px">1. Process</TD> <TD height="25px"> </TD> <TD height="25px"> </TD> </TR> </TBODY> </TABLE> <P> </P> <P>And I would like to do a where so that it looks like this:</P> <P> </P> <TABLE border="1"> <TBODY> <TR> <TD width="147.828px" height="25px">DATE</TD> <TD width="147px" height="25px">STAGE</TD> <TD width="147px" height="25px">DEPARTURE DATE</TD> <TD width="147px" height="25px">NEWSTAGE</TD> </TR> <TR> <TD width="147.828px" height="25px">03/02/2022 12:04:29</TD> <TD width="147px" height="25px">1. Process</TD> <TD width="147px" height="25px">03/02/2022</TD> <TD width="147px" height="25px"> </TD> </TR> <TR> <TD width="147.828px" height="28px">03/02/2022 13:17:24</TD> <TD width="147px" height="28px">1. Process</TD> <TD width="147px" height="28px">03/02/2022</TD> <TD width="147px" height="28px"> </TD> </TR> <TR> <TD width="147.828px" height="25px">03/02/2022 13:20:00</TD> <TD width="147px" height="25px">1. Process</TD> <TD width="147px" height="25px">03/02/2022</TD> <TD width="147px" height="25px"> </TD> </TR> <TR> <TD width="147.828px" height="25px">03/02/2022  13:25:00</TD> <TD width="147px" height="25px">-------</TD> <TD width="147px" height="25px"> </TD> <TD width="147px" height="25px">1.4 Process</TD> </TR> </TBODY> </TABLE> <P> </P> <P>Every time a 1.4 Process stage is found, it keeps the previous information</P> <P> </P> Thu, 31 Mar 2022 15:08:17 GMT https://community.qlik.com/t5/QlikView/Where-with-this-condition/m-p/1912609#M1218230 Aldemarprins4 2022-03-31T15:08:17Z