topic Last Log in App Development https://community.qlik.com/t5/App-Development/Last-Log/m-p/2010798#M83584 <P>Hello everyone,</P> <P>I need your support to create a table that starting from an observation date, returns me the volumes of contracts divided by state. The starting point is a table where logs are recorded in time stamp format.<BR />I need to create a date in DD/MM/YYY format, and then the count of practices based on the status present in the last daily log.<BR />Also, if on the day following the log entry, no status changes result, the status of the day should be taken <BR />I attach starting base and expected result.<BR />Thanks for those who can help me.</P> <P>Ps. Only in set analysis</P> <TABLE width="431"> <TBODY> <TR> <TD width="135">contract_id_bbus_log</TD> <TD width="134">event_date_bbus_log</TD> <TD width="162">proposal_status_bbus_log</TD> </TR> <TR> <TD>5000000000</TD> <TD>15/03/2021 12:32</TD> <TD>DRAFT</TD> </TR> <TR> <TD>5000000000</TD> <TD>16/03/2021 11:22</TD> <TD>DRAFT</TD> </TR> <TR> <TD>5000000000</TD> <TD>16/03/2021 12:48</TD> <TD>DRAFT</TD> </TR> <TR> <TD>5000000000</TD> <TD>16/03/2021 12:53</TD> <TD>DRAFT</TD> </TR> <TR> <TD>5000000000</TD> <TD>17/03/2021 17:02</TD> <TD>IPT</TD> </TR> <TR> <TD>5000000000</TD> <TD>17/03/2021 20:06</TD> <TD>APP</TD> </TR> <TR> <TD>5000000000</TD> <TD>17/03/2021 20:06</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>17/03/2021 20:34</TD> <TD>APP</TD> </TR> <TR> <TD>5000000000</TD> <TD>17/03/2021 20:35</TD> <TD>APP</TD> </TR> <TR> <TD>5000000000</TD> <TD>17/03/2021 20:35</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>19/03/2021 11:36</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>19/03/2021 12:01</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>19/03/2021 12:04</TD> <TD>SUS</TD> </TR> <TR> <TD>5000000000</TD> <TD>19/03/2021 12:04</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>19/03/2021 12:05</TD> <TD>SUS</TD> </TR> <TR> <TD>5000000000</TD> <TD>19/03/2021 13:49</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>19/03/2021 13:51</TD> <TD>SUS</TD> </TR> <TR> <TD>5000000000</TD> <TD>19/03/2021 13:58</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>20/03/2021 13:23</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>24/03/2021 14:44</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>24/03/2021 14:44</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>25/03/2021 14:31</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>26/03/2021 18:50</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>26/03/2021 19:03</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>26/03/2021 19:04</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>29/03/2021 19:11</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>29/03/2021 19:25</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>29/03/2021 19:25</TD> <TD>APP</TD> </TR> <TR> <TD>5000000000</TD> <TD>17/05/2021 11:17</TD> <TD>APP</TD> </TR> <TR> <TD>5000000004</TD> <TD>17/03/2021 14:30</TD> <TD>DRAFT</TD> </TR> <TR> <TD>5000000004</TD> <TD>17/03/2021 16:56</TD> <TD>IPT</TD> </TR> <TR> <TD>5000000004</TD> <TD>17/03/2021 20:20</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000004</TD> <TD>17/03/2021 20:26</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000004</TD> <TD>18/03/2021 12:33</TD> <TD>IPT</TD> </TR> <TR> <TD>5000000004</TD> <TD>18/03/2021 12:34</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000004</TD> <TD>18/03/2021 14:36</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000004</TD> <TD>18/03/2021 14:37</TD> <TD>APP</TD> </TR> <TR> <TD>5000000004</TD> <TD>18/03/2021 15:15</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000004</TD> <TD>18/03/2021 17:44</TD> <TD>IPD</TD> </TR> <TR> <TD>5000000004</TD> <TD>18/03/2021 17:45</TD> <TD>IPT</TD> </TR> <TR> <TD>5000000004</TD> <TD>18/03/2021 17:46</TD> <TD>IPF</TD> </TR> </TBODY> </TABLE> <P> </P> <P> </P> <P>Risultato atteso </P> <P> </P> <TABLE width="525"> <TBODY> <TR> <TD width="115">Observation Date</TD> <TD width="82">DRAFT</TD> <TD width="82">IPT</TD> <TD width="82">APP</TD> <TD width="82">SUS </TD> <TD width="82">IPF</TD> </TR> <TR> <TD>15/03/2021</TD> <TD>2</TD> <TD>4</TD> <TD>6</TD> <TD>4</TD> <TD>3</TD> </TR> <TR> <TD>16/03/2021</TD> <TD>3</TD> <TD>3</TD> <TD>2</TD> <TD>9</TD> <TD>7</TD> </TR> <TR> <TD>17/03/2021</TD> <TD>3</TD> <TD>9</TD> <TD>8</TD> <TD>6</TD> <TD>5</TD> </TR> <TR> <TD>18/03/2021</TD> <TD>2</TD> <TD>6</TD> <TD>5</TD> <TD>3</TD> <TD>5</TD> </TR> <TR> <TD>19/03/2021</TD> <TD>8</TD> <TD>1</TD> <TD>8</TD> <TD>9</TD> <TD>5</TD> </TR> </TBODY> </TABLE> Wed, 30 Nov 2022 09:23:40 GMT Max75 2022-11-30T09:23:40Z Last Log https://community.qlik.com/t5/App-Development/Last-Log/m-p/2010798#M83584 <P>Hello everyone,</P> <P>I need your support to create a table that starting from an observation date, returns me the volumes of contracts divided by state. The starting point is a table where logs are recorded in time stamp format.<BR />I need to create a date in DD/MM/YYY format, and then the count of practices based on the status present in the last daily log.<BR />Also, if on the day following the log entry, no status changes result, the status of the day should be taken <BR />I attach starting base and expected result.<BR />Thanks for those who can help me.</P> <P>Ps. Only in set analysis</P> <TABLE width="431"> <TBODY> <TR> <TD width="135">contract_id_bbus_log</TD> <TD width="134">event_date_bbus_log</TD> <TD width="162">proposal_status_bbus_log</TD> </TR> <TR> <TD>5000000000</TD> <TD>15/03/2021 12:32</TD> <TD>DRAFT</TD> </TR> <TR> <TD>5000000000</TD> <TD>16/03/2021 11:22</TD> <TD>DRAFT</TD> </TR> <TR> <TD>5000000000</TD> <TD>16/03/2021 12:48</TD> <TD>DRAFT</TD> </TR> <TR> <TD>5000000000</TD> <TD>16/03/2021 12:53</TD> <TD>DRAFT</TD> </TR> <TR> <TD>5000000000</TD> <TD>17/03/2021 17:02</TD> <TD>IPT</TD> </TR> <TR> <TD>5000000000</TD> <TD>17/03/2021 20:06</TD> <TD>APP</TD> </TR> <TR> <TD>5000000000</TD> <TD>17/03/2021 20:06</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>17/03/2021 20:34</TD> <TD>APP</TD> </TR> <TR> <TD>5000000000</TD> <TD>17/03/2021 20:35</TD> <TD>APP</TD> </TR> <TR> <TD>5000000000</TD> <TD>17/03/2021 20:35</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>19/03/2021 11:36</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>19/03/2021 12:01</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>19/03/2021 12:04</TD> <TD>SUS</TD> </TR> <TR> <TD>5000000000</TD> <TD>19/03/2021 12:04</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>19/03/2021 12:05</TD> <TD>SUS</TD> </TR> <TR> <TD>5000000000</TD> <TD>19/03/2021 13:49</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>19/03/2021 13:51</TD> <TD>SUS</TD> </TR> <TR> <TD>5000000000</TD> <TD>19/03/2021 13:58</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>20/03/2021 13:23</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>24/03/2021 14:44</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>24/03/2021 14:44</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>25/03/2021 14:31</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>26/03/2021 18:50</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>26/03/2021 19:03</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>26/03/2021 19:04</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>29/03/2021 19:11</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>29/03/2021 19:25</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000000</TD> <TD>29/03/2021 19:25</TD> <TD>APP</TD> </TR> <TR> <TD>5000000000</TD> <TD>17/05/2021 11:17</TD> <TD>APP</TD> </TR> <TR> <TD>5000000004</TD> <TD>17/03/2021 14:30</TD> <TD>DRAFT</TD> </TR> <TR> <TD>5000000004</TD> <TD>17/03/2021 16:56</TD> <TD>IPT</TD> </TR> <TR> <TD>5000000004</TD> <TD>17/03/2021 20:20</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000004</TD> <TD>17/03/2021 20:26</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000004</TD> <TD>18/03/2021 12:33</TD> <TD>IPT</TD> </TR> <TR> <TD>5000000004</TD> <TD>18/03/2021 12:34</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000004</TD> <TD>18/03/2021 14:36</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000004</TD> <TD>18/03/2021 14:37</TD> <TD>APP</TD> </TR> <TR> <TD>5000000004</TD> <TD>18/03/2021 15:15</TD> <TD>IPF</TD> </TR> <TR> <TD>5000000004</TD> <TD>18/03/2021 17:44</TD> <TD>IPD</TD> </TR> <TR> <TD>5000000004</TD> <TD>18/03/2021 17:45</TD> <TD>IPT</TD> </TR> <TR> <TD>5000000004</TD> <TD>18/03/2021 17:46</TD> <TD>IPF</TD> </TR> </TBODY> </TABLE> <P> </P> <P> </P> <P>Risultato atteso </P> <P> </P> <TABLE width="525"> <TBODY> <TR> <TD width="115">Observation Date</TD> <TD width="82">DRAFT</TD> <TD width="82">IPT</TD> <TD width="82">APP</TD> <TD width="82">SUS </TD> <TD width="82">IPF</TD> </TR> <TR> <TD>15/03/2021</TD> <TD>2</TD> <TD>4</TD> <TD>6</TD> <TD>4</TD> <TD>3</TD> </TR> <TR> <TD>16/03/2021</TD> <TD>3</TD> <TD>3</TD> <TD>2</TD> <TD>9</TD> <TD>7</TD> </TR> <TR> <TD>17/03/2021</TD> <TD>3</TD> <TD>9</TD> <TD>8</TD> <TD>6</TD> <TD>5</TD> </TR> <TR> <TD>18/03/2021</TD> <TD>2</TD> <TD>6</TD> <TD>5</TD> <TD>3</TD> <TD>5</TD> </TR> <TR> <TD>19/03/2021</TD> <TD>8</TD> <TD>1</TD> <TD>8</TD> <TD>9</TD> <TD>5</TD> </TR> </TBODY> </TABLE> Wed, 30 Nov 2022 09:23:40 GMT https://community.qlik.com/t5/App-Development/Last-Log/m-p/2010798#M83584 Max75 2022-11-30T09:23:40Z