topic Logfile: Keep status on several days till new status in App Development https://community.qlik.com/t5/App-Development/Logfile-Keep-status-on-several-days-till-new-status/m-p/1780442#M60701 <P>Hi experts,</P><P>I get a logfile that gives me the status changes per part number on daily basis simlilar to:</P><TABLE border="1"><TBODY><TR><TD>Day</TD><TD>Part number</TD><TD>status</TD></TR><TR><TD>01.01.2021</TD><TD>1</TD><TD><FONT color="#FF0000">red</FONT></TD></TR><TR><TD>05.01.2021</TD><TD>1</TD><TD><FONT color="#FF0000">red</FONT></TD></TR><TR><TD>10.01.2021</TD><TD>1</TD><TD><FONT color="#FFCC00">yellow</FONT></TD></TR><TR><TD>17.01.2021</TD><TD>1</TD><TD><FONT color="#008000">green</FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The user wants to see something like in the picture: count on part numbers per day stacked by the status (red, yellow, green) (-ignore the blue lines etc for now).</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SwenWa_0-1612512999915.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/48569i671DEE89E9F98A99/image-size/medium?v=v2&amp;px=400" role="button" title="SwenWa_0-1612512999915.png" alt="SwenWa_0-1612512999915.png" /></span></P><P>Obviously at the moment I count the part number 1 only when there is a record on the day (e.g. 01.01.2021).&nbsp;</P><P>-&gt; how can I manage it, that the part number 1 also counts on the days between the record days in the logfile e.g. 02.01.2021 (red) or 15.01.2021 (yellow) or 20.01.2021 (green)?&nbsp;</P><P>I thought of something like "valid from ..." - "valid to..." but I do not know how to manage this? Please help me <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>Thanks <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Sat, 16 Nov 2024 17:31:14 GMT SwenWa 2024-11-16T17:31:14Z Logfile: Keep status on several days till new status https://community.qlik.com/t5/App-Development/Logfile-Keep-status-on-several-days-till-new-status/m-p/1780442#M60701 <P>Hi experts,</P><P>I get a logfile that gives me the status changes per part number on daily basis simlilar to:</P><TABLE border="1"><TBODY><TR><TD>Day</TD><TD>Part number</TD><TD>status</TD></TR><TR><TD>01.01.2021</TD><TD>1</TD><TD><FONT color="#FF0000">red</FONT></TD></TR><TR><TD>05.01.2021</TD><TD>1</TD><TD><FONT color="#FF0000">red</FONT></TD></TR><TR><TD>10.01.2021</TD><TD>1</TD><TD><FONT color="#FFCC00">yellow</FONT></TD></TR><TR><TD>17.01.2021</TD><TD>1</TD><TD><FONT color="#008000">green</FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The user wants to see something like in the picture: count on part numbers per day stacked by the status (red, yellow, green) (-ignore the blue lines etc for now).</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SwenWa_0-1612512999915.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/48569i671DEE89E9F98A99/image-size/medium?v=v2&amp;px=400" role="button" title="SwenWa_0-1612512999915.png" alt="SwenWa_0-1612512999915.png" /></span></P><P>Obviously at the moment I count the part number 1 only when there is a record on the day (e.g. 01.01.2021).&nbsp;</P><P>-&gt; how can I manage it, that the part number 1 also counts on the days between the record days in the logfile e.g. 02.01.2021 (red) or 15.01.2021 (yellow) or 20.01.2021 (green)?&nbsp;</P><P>I thought of something like "valid from ..." - "valid to..." but I do not know how to manage this? Please help me <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>Thanks <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Sat, 16 Nov 2024 17:31:14 GMT https://community.qlik.com/t5/App-Development/Logfile-Keep-status-on-several-days-till-new-status/m-p/1780442#M60701 SwenWa 2024-11-16T17:31:14Z