https://community.qlik.com/t5/QlikView/Flag-setup/m-p/1982851#M1221083 <P>Hi , I need help in setting a flag - In the following data I have 3 rows , The flag needs to be set per Token based on the Status.</P> <P>1. All 1st Entry flagged - that I got right by using&nbsp; If(match(Status,'1st Entry'),1) as FlagEntry,</P> <P>2. Flag Exit status based on previous status - If Exit comes after a 1st Entry or Transfer = Flag 0 if Exit comes after an Exit or no value =Flag 1</P> <TABLE width="407"> <TBODY> <TR> <TD width="131">Token</TD> <TD width="67">Status</TD> <TD width="102">TImestamp</TD> <TD width="107">Desired Flag output</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>1st Entry</TD> <TD>18-09-2022 08:02</TD> <TD>1</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>Exit</TD> <TD>18-09-2022 08:08</TD> <TD>0</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>Transfer</TD> <TD>18-09-2022 08:09</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>Exit</TD> <TD>18-09-2022 08:10</TD> <TD>0</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>Exit</TD> <TD>18-09-2022 08:19</TD> <TD>1</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>Exit</TD> <TD>18-09-2022 08:34</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>1st Entry</TD> <TD>17-09-2022 04:42</TD> <TD>1</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>Exit</TD> <TD>17-09-2022 04:55</TD> <TD>0</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>1st Entry</TD> <TD>17-09-2022 09:18</TD> <TD>1</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>Exit</TD> <TD>17-09-2022 09:42</TD> <TD>0</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>Exit</TD> <TD>17-09-2022 09:43</TD> <TD>1</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>1st Entry</TD> <TD>18-09-2022 04:08</TD> <TD>1</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>1st Entry</TD> <TD>18-09-2022 04:23</TD> <TD>1</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Exit</TD> <TD>18-09-2022 04:25</TD> <TD>0</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Exit</TD> <TD>18-09-2022 04:29</TD> <TD>1</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Transfer</TD> <TD>18-09-2022 06:22</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Exit</TD> <TD>18-09-2022 06:27</TD> <TD>0</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Exit</TD> <TD>18-09-2022 06:46</TD> <TD>1</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>1st Entry</TD> <TD>18-09-2022 08:14</TD> <TD>1</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Exit</TD> <TD>18-09-2022 08:14</TD> <TD>0</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Transfer</TD> <TD>18-09-2022 08:15</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Exit</TD> <TD>18-09-2022 08:21</TD> <TD>0</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Exit</TD> <TD>18-09-2022 08:52</TD> <TD>1</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Transfer</TD> <TD>18-09-2022 08:52</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Transfer</TD> <TD>18-09-2022 08:58</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Exit</TD> <TD>18-09-2022 08:59</TD> <TD>0</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Transfer</TD> <TD>18-09-2022 09:00</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Exit</TD> <TD>18-09-2022 09:06</TD> <TD>0</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Exit</TD> <TD>18-09-2022 09:14</TD> <TD>1</TD> </TR> </TBODY> </TABLE> Tue, 20 Sep 2022 04:24:41 GMT Ironzem 2022-09-20T04:24:41Z https://community.qlik.com/t5/QlikView/Flag-setup/m-p/1982851#M1221083 <P>Hi , I need help in setting a flag - In the following data I have 3 rows , The flag needs to be set per Token based on the Status.</P> <P>1. All 1st Entry flagged - that I got right by using&nbsp; If(match(Status,'1st Entry'),1) as FlagEntry,</P> <P>2. Flag Exit status based on previous status - If Exit comes after a 1st Entry or Transfer = Flag 0 if Exit comes after an Exit or no value =Flag 1</P> <TABLE width="407"> <TBODY> <TR> <TD width="131">Token</TD> <TD width="67">Status</TD> <TD width="102">TImestamp</TD> <TD width="107">Desired Flag output</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>1st Entry</TD> <TD>18-09-2022 08:02</TD> <TD>1</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>Exit</TD> <TD>18-09-2022 08:08</TD> <TD>0</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>Transfer</TD> <TD>18-09-2022 08:09</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>Exit</TD> <TD>18-09-2022 08:10</TD> <TD>0</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>Exit</TD> <TD>18-09-2022 08:19</TD> <TD>1</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>Exit</TD> <TD>18-09-2022 08:34</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>1st Entry</TD> <TD>17-09-2022 04:42</TD> <TD>1</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>Exit</TD> <TD>17-09-2022 04:55</TD> <TD>0</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>1st Entry</TD> <TD>17-09-2022 09:18</TD> <TD>1</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>Exit</TD> <TD>17-09-2022 09:42</TD> <TD>0</TD> </TR> <TR> <TD>444733439845528493</TD> <TD>Exit</TD> <TD>17-09-2022 09:43</TD> <TD>1</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>1st Entry</TD> <TD>18-09-2022 04:08</TD> <TD>1</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>1st Entry</TD> <TD>18-09-2022 04:23</TD> <TD>1</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Exit</TD> <TD>18-09-2022 04:25</TD> <TD>0</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Exit</TD> <TD>18-09-2022 04:29</TD> <TD>1</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Transfer</TD> <TD>18-09-2022 06:22</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Exit</TD> <TD>18-09-2022 06:27</TD> <TD>0</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Exit</TD> <TD>18-09-2022 06:46</TD> <TD>1</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>1st Entry</TD> <TD>18-09-2022 08:14</TD> <TD>1</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Exit</TD> <TD>18-09-2022 08:14</TD> <TD>0</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Transfer</TD> <TD>18-09-2022 08:15</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Exit</TD> <TD>18-09-2022 08:21</TD> <TD>0</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Exit</TD> <TD>18-09-2022 08:52</TD> <TD>1</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Transfer</TD> <TD>18-09-2022 08:52</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Transfer</TD> <TD>18-09-2022 08:58</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Exit</TD> <TD>18-09-2022 08:59</TD> <TD>0</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Transfer</TD> <TD>18-09-2022 09:00</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Exit</TD> <TD>18-09-2022 09:06</TD> <TD>0</TD> </TR> <TR> <TD>17839739266241238273</TD> <TD>Exit</TD> <TD>18-09-2022 09:14</TD> <TD>1</TD> </TR> </TBODY> </TABLE> Tue, 20 Sep 2022 04:24:41 GMT https://community.qlik.com/t5/QlikView/Flag-setup/m-p/1982851#M1221083 Ironzem 2022-09-20T04:24:41Z https://community.qlik.com/t5/QlikView/Flag-setup/m-p/1988782#M1221245 <P><SPAN>If(Status = '1st Entry', 1, i</SPAN><SPAN>f(peek(Status) = 'Exit'), 1, 0))</SPAN></P> Tue, 04 Oct 2022 16:33:56 GMT https://community.qlik.com/t5/QlikView/Flag-setup/m-p/1988782#M1221245 lockematthewp 2022-10-04T16:33:56Z https://community.qlik.com/t5/QlikView/Flag-setup/m-p/1991123#M1221267 <P>Thank you</P> Tue, 11 Oct 2022 07:15:57 GMT https://community.qlik.com/t5/QlikView/Flag-setup/m-p/1991123#M1221267 Ironzem 2022-10-11T07:15:57Z