topic Count Days Between First Time Status Change in App Development

topic Count Days Between First Time Status Change in App Development https://community.qlik.com/t5/App-Development/Count-Days-Between-First-Time-Status-Change/m-p/1736608#M56327 <P>Hi guys, </P><P>This is my data</P><TABLE width="513"><TBODY><TR><TD width="97">Customer</TD><TD width="90">Account</TD><TD width="129">Date</TD><TD width="105">Balance</TD><TD width="92">Status</TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">01/04/2020</FONT></TD><TD><FONT color="#0000FF">-100</FONT></TD><TD><FONT color="#0000FF">Exceed</FONT></TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">02/04/2020</FONT></TD><TD><FONT color="#0000FF">-150</FONT></TD><TD><FONT color="#0000FF">Exceed</FONT></TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">03/04/2020</FONT></TD><TD><FONT color="#0000FF">200</FONT></TD><TD><FONT color="#0000FF">Normal</FONT></TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">20/04/2020</FONT></TD><TD><FONT color="#0000FF">-120</FONT></TD><TD><FONT color="#0000FF">Exceed</FONT></TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">10/05/2020</FONT></TD><TD><FONT color="#0000FF">-110</FONT></TD><TD><FONT color="#0000FF">Exceed</FONT></TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">05/06/2020</FONT></TD><TD><FONT color="#0000FF">20</FONT></TD><TD><FONT color="#0000FF">Normal</FONT></TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">30/07/2020</FONT></TD><TD><FONT color="#0000FF">-60</FONT></TD><TD><FONT color="#0000FF">Exceed</FONT></TD></TR><TR><TD><FONT color="#008000">1</FONT></TD><TD><FONT color="#008000">1002</FONT></TD><TD><FONT color="#008000">01/04/2020</FONT></TD><TD><FONT color="#008000">180</FONT></TD><TD><FONT color="#008000">Normal</FONT></TD></TR><TR><TD><FONT color="#008000">1</FONT></TD><TD><FONT color="#008000">1002</FONT></TD><TD><FONT color="#008000">10/04/2020</FONT></TD><TD><FONT color="#008000">-90</FONT></TD><TD><FONT color="#008000">Exceed</FONT></TD></TR><TR><TD><FONT color="#008000">1</FONT></TD><TD><FONT color="#008000">1002</FONT></TD><TD><FONT color="#008000">30/04/2020</FONT></TD><TD><FONT color="#008000">220</FONT></TD><TD><FONT color="#008000">Normal</FONT></TD></TR><TR><TD><FONT color="#008000">1</FONT></TD><TD><FONT color="#008000">1002</FONT></TD><TD><FONT color="#008000">10/05/2020</FONT></TD><TD><FONT color="#008000">230</FONT></TD><TD><FONT color="#008000">Normal</FONT></TD></TR><TR><TD><FONT color="#008000">1</FONT></TD><TD><FONT color="#008000">1002</FONT></TD><TD><FONT color="#008000">12/05/2020</FONT></TD><TD><FONT color="#008000">-140</FONT></TD><TD><FONT color="#008000">Exceed</FONT></TD></TR><TR><TD><FONT color="#008000">1</FONT></TD><TD><FONT color="#008000">1002</FONT></TD><TD><FONT color="#008000">08/08/2020</FONT></TD><TD><FONT color="#008000">110</FONT></TD><TD><FONT color="#008000">Normal</FONT></TD></TR><TR><TD>2</TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">10/04/2020</FONT></TD><TD><FONT color="#800080">290</FONT></TD><TD><FONT color="#800080">Normal</FONT></TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">15/04/2020</FONT></TD><TD><FONT color="#800080">-300</FONT></TD><TD><FONT color="#800080">Exceed</FONT></TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">30/04/2020</FONT></TD><TD><FONT color="#800080">350</FONT></TD><TD><FONT color="#800080">Normal</FONT></TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">15/05/2020</FONT></TD><TD><FONT color="#800080">320</FONT></TD><TD><FONT color="#800080">Normal</FONT></TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">12/07/2020</FONT></TD><TD><FONT color="#800080">-450</FONT></TD><TD><FONT color="#800080">Exceed</FONT></TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">02/08/2020</FONT></TD><TD><FONT color="#800080">-600</FONT></TD><TD><FONT color="#800080">Exceed</FONT></TD></TR></TBODY></TABLE><P> </P><P>I want to Display for each Account:</P><P>1 - The Last Time the status change from normal to Exceed.</P><P>2 - Today Status ( Last Status ).</P><P>3 - How many time the Status change from Normal to Exceed.</P><P>4 - Total Exceed days.</P><P>This is the output:</P><TABLE width="756"><TBODY><TR><TD width="89px" height="47px">Customer</TD><TD width="119px" height="47px">Account</TD><TD width="146px" height="47px">Last Time Start Exceed</TD><TD width="122px" height="47px">Today Status</TD><TD width="128px" height="47px">Times went Exceed</TD><TD width="151px" height="47px">Total Exceed Days</TD></TR><TR><TD width="89px" height="25px"><FONT color="#0000FF">1</FONT></TD><TD width="119px" height="25px"><FONT color="#0000FF">1001</FONT></TD><TD width="146px" height="25px"><FONT color="#0000FF">30/07/2020</FONT></TD><TD width="122px" height="25px"><FONT color="#0000FF">Exceed</FONT></TD><TD width="128px" height="25px"><FONT color="#0000FF">3</FONT></TD><TD width="151px" height="25px"><FONT color="#0000FF">48</FONT></TD></TR><TR><TD width="89px" height="25px"><FONT color="#339966">1</FONT></TD><TD width="119px" height="25px"><FONT color="#339966">1002</FONT></TD><TD width="146px" height="25px"><FONT color="#339966">12/05/2020</FONT></TD><TD width="122px" height="25px"><FONT color="#339966">Normal</FONT></TD><TD width="128px" height="25px"><FONT color="#339966">2</FONT></TD><TD width="151px" height="25px"><FONT color="#339966">108</FONT></TD></TR><TR><TD width="89px" height="25px"><FONT color="#800080">2</FONT></TD><TD width="119px" height="25px"><FONT color="#800080">1003</FONT></TD><TD width="146px" height="25px"><FONT color="#800080">12/07/2020</FONT></TD><TD width="122px" height="25px"><FONT color="#800080">Exceed</FONT></TD><TD width="128px" height="25px"><FONT color="#800080">2</FONT></TD><TD width="151px" height="25px"><FONT color="#800080">15</FONT></TD></TR></TBODY></TABLE><P> </P><P>And</P><TABLE width="756"><TBODY><TR><TD width="90">Customer</TD><TD width="119">Account</TD><TD width="146">Date</TD><TD width="122">Balance</TD><TD width="128">Status</TD><TD width="151">Days To Back to normal</TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">01/04/2020</FONT></TD><TD><FONT color="#0000FF">-100</FONT></TD><TD><FONT color="#0000FF">Exceed</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">02/04/2020</FONT></TD><TD><FONT color="#0000FF">-150</FONT></TD><TD><FONT color="#0000FF">Exceed</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">03/04/2020</FONT></TD><TD><FONT color="#0000FF">200</FONT></TD><TD><FONT color="#0000FF">Normal</FONT></TD><TD><FONT color="#0000FF">2</FONT></TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">20/04/2020</FONT></TD><TD><FONT color="#0000FF">-120</FONT></TD><TD><FONT color="#0000FF">Exceed</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">10/05/2020</FONT></TD><TD><FONT color="#0000FF">-110</FONT></TD><TD><FONT color="#0000FF">Exceed</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">05/06/2020</FONT></TD><TD><FONT color="#0000FF">20</FONT></TD><TD><FONT color="#0000FF">Normal</FONT></TD><TD><FONT color="#0000FF">46</FONT></TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">30/07/2020</FONT></TD><TD><FONT color="#0000FF">-60</FONT></TD><TD><FONT color="#0000FF">Exceed</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#339966">1</FONT></TD><TD><FONT color="#339966">1002</FONT></TD><TD><FONT color="#339966">01/04/2020</FONT></TD><TD><FONT color="#339966">180</FONT></TD><TD><FONT color="#339966">Normal</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#339966">1</FONT></TD><TD><FONT color="#339966">1002</FONT></TD><TD><FONT color="#339966">10/04/2020</FONT></TD><TD><FONT color="#339966">-90</FONT></TD><TD><FONT color="#339966">Exceed</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#339966">1</FONT></TD><TD><FONT color="#339966">1002</FONT></TD><TD><FONT color="#339966">30/04/2020</FONT></TD><TD><FONT color="#339966">220</FONT></TD><TD><FONT color="#339966">Normal</FONT></TD><TD><FONT color="#339966">20</FONT></TD></TR><TR><TD><FONT color="#339966">1</FONT></TD><TD><FONT color="#339966">1002</FONT></TD><TD><FONT color="#339966">10/05/2020</FONT></TD><TD><FONT color="#339966">230</FONT></TD><TD><FONT color="#339966">Normal</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#339966">1</FONT></TD><TD><FONT color="#339966">1002</FONT></TD><TD><FONT color="#339966">12/05/2020</FONT></TD><TD><FONT color="#339966">-140</FONT></TD><TD><FONT color="#339966">Exceed</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#339966">1</FONT></TD><TD><FONT color="#339966">1002</FONT></TD><TD><FONT color="#339966">08/08/2020</FONT></TD><TD><FONT color="#339966">110</FONT></TD><TD><FONT color="#339966">Normal</FONT></TD><TD><FONT color="#339966">88</FONT></TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">10/04/2020</FONT></TD><TD><FONT color="#800080">290</FONT></TD><TD><FONT color="#800080">Normal</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">15/04/2020</FONT></TD><TD><FONT color="#800080">-300</FONT></TD><TD><FONT color="#800080">Exceed</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">30/04/2020</FONT></TD><TD><FONT color="#800080">350</FONT></TD><TD><FONT color="#800080">Normal</FONT></TD><TD><FONT color="#800080">15</FONT></TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">15/05/2020</FONT></TD><TD><FONT color="#800080">320</FONT></TD><TD><FONT color="#800080">Normal</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">12/07/2020</FONT></TD><TD><FONT color="#800080">-450</FONT></TD><TD><FONT color="#800080">Exceed</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">02/08/2020</FONT></TD><TD><FONT color="#800080">-600</FONT></TD><TD><FONT color="#800080">Exceed</FONT></TD><TD> </TD></TR></TBODY></TABLE><P> </P><P>Please find attached excel for more clarification</P><P>Thank you in advance</P> Tue, 18 Aug 2020 07:24:00 GMT ch_riadh 2020-08-18T07:24:00Z Count Days Between First Time Status Change https://community.qlik.com/t5/App-Development/Count-Days-Between-First-Time-Status-Change/m-p/1736608#M56327 <P>Hi guys, </P><P>This is my data</P><TABLE width="513"><TBODY><TR><TD width="97">Customer</TD><TD width="90">Account</TD><TD width="129">Date</TD><TD width="105">Balance</TD><TD width="92">Status</TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">01/04/2020</FONT></TD><TD><FONT color="#0000FF">-100</FONT></TD><TD><FONT color="#0000FF">Exceed</FONT></TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">02/04/2020</FONT></TD><TD><FONT color="#0000FF">-150</FONT></TD><TD><FONT color="#0000FF">Exceed</FONT></TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">03/04/2020</FONT></TD><TD><FONT color="#0000FF">200</FONT></TD><TD><FONT color="#0000FF">Normal</FONT></TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">20/04/2020</FONT></TD><TD><FONT color="#0000FF">-120</FONT></TD><TD><FONT color="#0000FF">Exceed</FONT></TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">10/05/2020</FONT></TD><TD><FONT color="#0000FF">-110</FONT></TD><TD><FONT color="#0000FF">Exceed</FONT></TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">05/06/2020</FONT></TD><TD><FONT color="#0000FF">20</FONT></TD><TD><FONT color="#0000FF">Normal</FONT></TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">30/07/2020</FONT></TD><TD><FONT color="#0000FF">-60</FONT></TD><TD><FONT color="#0000FF">Exceed</FONT></TD></TR><TR><TD><FONT color="#008000">1</FONT></TD><TD><FONT color="#008000">1002</FONT></TD><TD><FONT color="#008000">01/04/2020</FONT></TD><TD><FONT color="#008000">180</FONT></TD><TD><FONT color="#008000">Normal</FONT></TD></TR><TR><TD><FONT color="#008000">1</FONT></TD><TD><FONT color="#008000">1002</FONT></TD><TD><FONT color="#008000">10/04/2020</FONT></TD><TD><FONT color="#008000">-90</FONT></TD><TD><FONT color="#008000">Exceed</FONT></TD></TR><TR><TD><FONT color="#008000">1</FONT></TD><TD><FONT color="#008000">1002</FONT></TD><TD><FONT color="#008000">30/04/2020</FONT></TD><TD><FONT color="#008000">220</FONT></TD><TD><FONT color="#008000">Normal</FONT></TD></TR><TR><TD><FONT color="#008000">1</FONT></TD><TD><FONT color="#008000">1002</FONT></TD><TD><FONT color="#008000">10/05/2020</FONT></TD><TD><FONT color="#008000">230</FONT></TD><TD><FONT color="#008000">Normal</FONT></TD></TR><TR><TD><FONT color="#008000">1</FONT></TD><TD><FONT color="#008000">1002</FONT></TD><TD><FONT color="#008000">12/05/2020</FONT></TD><TD><FONT color="#008000">-140</FONT></TD><TD><FONT color="#008000">Exceed</FONT></TD></TR><TR><TD><FONT color="#008000">1</FONT></TD><TD><FONT color="#008000">1002</FONT></TD><TD><FONT color="#008000">08/08/2020</FONT></TD><TD><FONT color="#008000">110</FONT></TD><TD><FONT color="#008000">Normal</FONT></TD></TR><TR><TD>2</TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">10/04/2020</FONT></TD><TD><FONT color="#800080">290</FONT></TD><TD><FONT color="#800080">Normal</FONT></TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">15/04/2020</FONT></TD><TD><FONT color="#800080">-300</FONT></TD><TD><FONT color="#800080">Exceed</FONT></TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">30/04/2020</FONT></TD><TD><FONT color="#800080">350</FONT></TD><TD><FONT color="#800080">Normal</FONT></TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">15/05/2020</FONT></TD><TD><FONT color="#800080">320</FONT></TD><TD><FONT color="#800080">Normal</FONT></TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">12/07/2020</FONT></TD><TD><FONT color="#800080">-450</FONT></TD><TD><FONT color="#800080">Exceed</FONT></TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">02/08/2020</FONT></TD><TD><FONT color="#800080">-600</FONT></TD><TD><FONT color="#800080">Exceed</FONT></TD></TR></TBODY></TABLE><P> </P><P>I want to Display for each Account:</P><P>1 - The Last Time the status change from normal to Exceed.</P><P>2 - Today Status ( Last Status ).</P><P>3 - How many time the Status change from Normal to Exceed.</P><P>4 - Total Exceed days.</P><P>This is the output:</P><TABLE width="756"><TBODY><TR><TD width="89px" height="47px">Customer</TD><TD width="119px" height="47px">Account</TD><TD width="146px" height="47px">Last Time Start Exceed</TD><TD width="122px" height="47px">Today Status</TD><TD width="128px" height="47px">Times went Exceed</TD><TD width="151px" height="47px">Total Exceed Days</TD></TR><TR><TD width="89px" height="25px"><FONT color="#0000FF">1</FONT></TD><TD width="119px" height="25px"><FONT color="#0000FF">1001</FONT></TD><TD width="146px" height="25px"><FONT color="#0000FF">30/07/2020</FONT></TD><TD width="122px" height="25px"><FONT color="#0000FF">Exceed</FONT></TD><TD width="128px" height="25px"><FONT color="#0000FF">3</FONT></TD><TD width="151px" height="25px"><FONT color="#0000FF">48</FONT></TD></TR><TR><TD width="89px" height="25px"><FONT color="#339966">1</FONT></TD><TD width="119px" height="25px"><FONT color="#339966">1002</FONT></TD><TD width="146px" height="25px"><FONT color="#339966">12/05/2020</FONT></TD><TD width="122px" height="25px"><FONT color="#339966">Normal</FONT></TD><TD width="128px" height="25px"><FONT color="#339966">2</FONT></TD><TD width="151px" height="25px"><FONT color="#339966">108</FONT></TD></TR><TR><TD width="89px" height="25px"><FONT color="#800080">2</FONT></TD><TD width="119px" height="25px"><FONT color="#800080">1003</FONT></TD><TD width="146px" height="25px"><FONT color="#800080">12/07/2020</FONT></TD><TD width="122px" height="25px"><FONT color="#800080">Exceed</FONT></TD><TD width="128px" height="25px"><FONT color="#800080">2</FONT></TD><TD width="151px" height="25px"><FONT color="#800080">15</FONT></TD></TR></TBODY></TABLE><P> </P><P>And</P><TABLE width="756"><TBODY><TR><TD width="90">Customer</TD><TD width="119">Account</TD><TD width="146">Date</TD><TD width="122">Balance</TD><TD width="128">Status</TD><TD width="151">Days To Back to normal</TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">01/04/2020</FONT></TD><TD><FONT color="#0000FF">-100</FONT></TD><TD><FONT color="#0000FF">Exceed</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">02/04/2020</FONT></TD><TD><FONT color="#0000FF">-150</FONT></TD><TD><FONT color="#0000FF">Exceed</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">03/04/2020</FONT></TD><TD><FONT color="#0000FF">200</FONT></TD><TD><FONT color="#0000FF">Normal</FONT></TD><TD><FONT color="#0000FF">2</FONT></TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">20/04/2020</FONT></TD><TD><FONT color="#0000FF">-120</FONT></TD><TD><FONT color="#0000FF">Exceed</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">10/05/2020</FONT></TD><TD><FONT color="#0000FF">-110</FONT></TD><TD><FONT color="#0000FF">Exceed</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">05/06/2020</FONT></TD><TD><FONT color="#0000FF">20</FONT></TD><TD><FONT color="#0000FF">Normal</FONT></TD><TD><FONT color="#0000FF">46</FONT></TD></TR><TR><TD><FONT color="#0000FF">1</FONT></TD><TD><FONT color="#0000FF">1001</FONT></TD><TD><FONT color="#0000FF">30/07/2020</FONT></TD><TD><FONT color="#0000FF">-60</FONT></TD><TD><FONT color="#0000FF">Exceed</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#339966">1</FONT></TD><TD><FONT color="#339966">1002</FONT></TD><TD><FONT color="#339966">01/04/2020</FONT></TD><TD><FONT color="#339966">180</FONT></TD><TD><FONT color="#339966">Normal</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#339966">1</FONT></TD><TD><FONT color="#339966">1002</FONT></TD><TD><FONT color="#339966">10/04/2020</FONT></TD><TD><FONT color="#339966">-90</FONT></TD><TD><FONT color="#339966">Exceed</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#339966">1</FONT></TD><TD><FONT color="#339966">1002</FONT></TD><TD><FONT color="#339966">30/04/2020</FONT></TD><TD><FONT color="#339966">220</FONT></TD><TD><FONT color="#339966">Normal</FONT></TD><TD><FONT color="#339966">20</FONT></TD></TR><TR><TD><FONT color="#339966">1</FONT></TD><TD><FONT color="#339966">1002</FONT></TD><TD><FONT color="#339966">10/05/2020</FONT></TD><TD><FONT color="#339966">230</FONT></TD><TD><FONT color="#339966">Normal</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#339966">1</FONT></TD><TD><FONT color="#339966">1002</FONT></TD><TD><FONT color="#339966">12/05/2020</FONT></TD><TD><FONT color="#339966">-140</FONT></TD><TD><FONT color="#339966">Exceed</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#339966">1</FONT></TD><TD><FONT color="#339966">1002</FONT></TD><TD><FONT color="#339966">08/08/2020</FONT></TD><TD><FONT color="#339966">110</FONT></TD><TD><FONT color="#339966">Normal</FONT></TD><TD><FONT color="#339966">88</FONT></TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">10/04/2020</FONT></TD><TD><FONT color="#800080">290</FONT></TD><TD><FONT color="#800080">Normal</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">15/04/2020</FONT></TD><TD><FONT color="#800080">-300</FONT></TD><TD><FONT color="#800080">Exceed</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">30/04/2020</FONT></TD><TD><FONT color="#800080">350</FONT></TD><TD><FONT color="#800080">Normal</FONT></TD><TD><FONT color="#800080">15</FONT></TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">15/05/2020</FONT></TD><TD><FONT color="#800080">320</FONT></TD><TD><FONT color="#800080">Normal</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">12/07/2020</FONT></TD><TD><FONT color="#800080">-450</FONT></TD><TD><FONT color="#800080">Exceed</FONT></TD><TD> </TD></TR><TR><TD><FONT color="#800080">2</FONT></TD><TD><FONT color="#800080">1003</FONT></TD><TD><FONT color="#800080">02/08/2020</FONT></TD><TD><FONT color="#800080">-600</FONT></TD><TD><FONT color="#800080">Exceed</FONT></TD><TD> </TD></TR></TBODY></TABLE><P> </P><P>Please find attached excel for more clarification</P><P>Thank you in advance</P> Tue, 18 Aug 2020 07:24:00 GMT https://community.qlik.com/t5/App-Development/Count-Days-Between-First-Time-Status-Change/m-p/1736608#M56327 ch_riadh 2020-08-18T07:24:00Z