topic Count Days between Status changes _ in App Development

topic Count Days between Status changes _ in App Development https://community.qlik.com/t5/App-Development/Count-Days-between-Status-changes/m-p/1736637#M56331 <P>This is my data</P><TABLE width="685"><TBODY><TR><TD width="119">Customer</TD><TD width="145">Account</TD><TD width="165">Date</TD><TD width="133">Balance</TD><TD width="123">Status</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>01/04/2020</TD><TD>-100</TD><TD>Exceed</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>02/04/2020</TD><TD>-150</TD><TD>Exceed</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>03/04/2020</TD><TD>200</TD><TD>Normal</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>20/04/2020</TD><TD>-120</TD><TD>Exceed</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>10/05/2020</TD><TD>-110</TD><TD>Exceed</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>05/06/2020</TD><TD>20</TD><TD>Normal</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>30/07/2020</TD><TD>-60</TD><TD>Exceed</TD></TR><TR><TD>1</TD><TD>1002</TD><TD>01/04/2020</TD><TD>180</TD><TD>Normal</TD></TR><TR><TD>1</TD><TD>1002</TD><TD>10/04/2020</TD><TD>-90</TD><TD>Exceed</TD></TR><TR><TD>1</TD><TD>1002</TD><TD>30/04/2020</TD><TD>220</TD><TD>Normal</TD></TR><TR><TD>1</TD><TD>1002</TD><TD>10/05/2020</TD><TD>230</TD><TD>Normal</TD></TR><TR><TD>1</TD><TD>1002</TD><TD>12/05/2020</TD><TD>-140</TD><TD>Exceed</TD></TR><TR><TD>1</TD><TD>1002</TD><TD>08/08/2020</TD><TD>110</TD><TD>Normal</TD></TR><TR><TD>2</TD><TD>1003</TD><TD>10/04/2020</TD><TD>290</TD><TD>Normal</TD></TR><TR><TD>2</TD><TD>1003</TD><TD>15/04/2020</TD><TD>-300</TD><TD>Exceed</TD></TR><TR><TD>2</TD><TD>1003</TD><TD>30/04/2020</TD><TD>350</TD><TD>Normal</TD></TR><TR><TD>2</TD><TD>1003</TD><TD>15/05/2020</TD><TD>320</TD><TD>Normal</TD></TR><TR><TD>2</TD><TD>1003</TD><TD>12/07/2020</TD><TD>-450</TD><TD>Exceed</TD></TR><TR><TD>2</TD><TD>1003</TD><TD>02/08/2020</TD><TD>-600</TD><TD>Exceed</TD></TR></TBODY></TABLE><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="723"><TBODY><TR><TD width="90">Customer</TD><TD width="119">Account</TD><TD width="146">Last Time Start Exceed</TD><TD width="89">Today Status</TD><TD width="128">Times went Exceed</TD><TD width="151">Total Exceed Days</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>30/07/2020</TD><TD>Exceed</TD><TD>3</TD><TD>48</TD></TR><TR><TD>1</TD><TD>1002</TD><TD>12/05/2020</TD><TD>Normal</TD><TD>2</TD><TD>108</TD></TR><TR><TD>2</TD><TD>1003</TD><TD>12/07/2020</TD><TD>Exceed</TD><TD>2</TD><TD>15</TD></TR></TBODY></TABLE><P> </P><P>and</P><TABLE width="723"><TBODY><TR><TD width="90">Customer</TD><TD width="119">Account</TD><TD width="146">Date</TD><TD width="89">Balance</TD><TD width="128">Status</TD><TD width="151">Days To Back to normal</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>01/04/2020</TD><TD>-100</TD><TD>Exceed</TD><TD> </TD></TR><TR><TD>1</TD><TD>1001</TD><TD>02/04/2020</TD><TD>-150</TD><TD>Exceed</TD><TD> </TD></TR><TR><TD>1</TD><TD>1001</TD><TD>03/04/2020</TD><TD>200</TD><TD>Normal</TD><TD>2</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>20/04/2020</TD><TD>-120</TD><TD>Exceed</TD><TD> </TD></TR><TR><TD>1</TD><TD>1001</TD><TD>10/05/2020</TD><TD>-110</TD><TD>Exceed</TD><TD> </TD></TR><TR><TD>1</TD><TD>1001</TD><TD>05/06/2020</TD><TD>20</TD><TD>Normal</TD><TD>46</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>30/07/2020</TD><TD>-60</TD><TD>Exceed</TD><TD> </TD></TR><TR><TD>1</TD><TD>1002</TD><TD>01/04/2020</TD><TD>180</TD><TD>Normal</TD><TD> </TD></TR><TR><TD>1</TD><TD>1002</TD><TD>10/04/2020</TD><TD>-90</TD><TD>Exceed</TD><TD> </TD></TR><TR><TD>1</TD><TD>1002</TD><TD>30/04/2020</TD><TD>220</TD><TD>Normal</TD><TD>20</TD></TR><TR><TD>1</TD><TD>1002</TD><TD>10/05/2020</TD><TD>230</TD><TD>Normal</TD><TD> </TD></TR><TR><TD>1</TD><TD>1002</TD><TD>12/05/2020</TD><TD>-140</TD><TD>Exceed</TD><TD> </TD></TR><TR><TD>1</TD><TD>1002</TD><TD>08/08/2020</TD><TD>110</TD><TD>Normal</TD><TD>88</TD></TR><TR><TD>2</TD><TD>1003</TD><TD>10/04/2020</TD><TD>290</TD><TD>Normal</TD><TD> </TD></TR><TR><TD>2</TD><TD>1003</TD><TD>15/04/2020</TD><TD>-300</TD><TD>Exceed</TD><TD> </TD></TR><TR><TD>2</TD><TD>1003</TD><TD>30/04/2020</TD><TD>350</TD><TD>Normal</TD><TD>15</TD></TR><TR><TD>2</TD><TD>1003</TD><TD>15/05/2020</TD><TD>320</TD><TD>Normal</TD><TD> </TD></TR><TR><TD>2</TD><TD>1003</TD><TD>12/07/2020</TD><TD>-450</TD><TD>Exceed</TD><TD> </TD></TR><TR><TD>2</TD><TD>1003</TD><TD>02/08/2020</TD><TD>-600</TD><TD>Exceed</TD><TD> </TD></TR></TBODY></TABLE> Tue, 18 Aug 2020 08:05:06 GMT ch_riadh 2020-08-18T08:05:06Z Count Days between Status changes _ https://community.qlik.com/t5/App-Development/Count-Days-between-Status-changes/m-p/1736637#M56331 <P>This is my data</P><TABLE width="685"><TBODY><TR><TD width="119">Customer</TD><TD width="145">Account</TD><TD width="165">Date</TD><TD width="133">Balance</TD><TD width="123">Status</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>01/04/2020</TD><TD>-100</TD><TD>Exceed</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>02/04/2020</TD><TD>-150</TD><TD>Exceed</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>03/04/2020</TD><TD>200</TD><TD>Normal</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>20/04/2020</TD><TD>-120</TD><TD>Exceed</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>10/05/2020</TD><TD>-110</TD><TD>Exceed</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>05/06/2020</TD><TD>20</TD><TD>Normal</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>30/07/2020</TD><TD>-60</TD><TD>Exceed</TD></TR><TR><TD>1</TD><TD>1002</TD><TD>01/04/2020</TD><TD>180</TD><TD>Normal</TD></TR><TR><TD>1</TD><TD>1002</TD><TD>10/04/2020</TD><TD>-90</TD><TD>Exceed</TD></TR><TR><TD>1</TD><TD>1002</TD><TD>30/04/2020</TD><TD>220</TD><TD>Normal</TD></TR><TR><TD>1</TD><TD>1002</TD><TD>10/05/2020</TD><TD>230</TD><TD>Normal</TD></TR><TR><TD>1</TD><TD>1002</TD><TD>12/05/2020</TD><TD>-140</TD><TD>Exceed</TD></TR><TR><TD>1</TD><TD>1002</TD><TD>08/08/2020</TD><TD>110</TD><TD>Normal</TD></TR><TR><TD>2</TD><TD>1003</TD><TD>10/04/2020</TD><TD>290</TD><TD>Normal</TD></TR><TR><TD>2</TD><TD>1003</TD><TD>15/04/2020</TD><TD>-300</TD><TD>Exceed</TD></TR><TR><TD>2</TD><TD>1003</TD><TD>30/04/2020</TD><TD>350</TD><TD>Normal</TD></TR><TR><TD>2</TD><TD>1003</TD><TD>15/05/2020</TD><TD>320</TD><TD>Normal</TD></TR><TR><TD>2</TD><TD>1003</TD><TD>12/07/2020</TD><TD>-450</TD><TD>Exceed</TD></TR><TR><TD>2</TD><TD>1003</TD><TD>02/08/2020</TD><TD>-600</TD><TD>Exceed</TD></TR></TBODY></TABLE><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="723"><TBODY><TR><TD width="90">Customer</TD><TD width="119">Account</TD><TD width="146">Last Time Start Exceed</TD><TD width="89">Today Status</TD><TD width="128">Times went Exceed</TD><TD width="151">Total Exceed Days</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>30/07/2020</TD><TD>Exceed</TD><TD>3</TD><TD>48</TD></TR><TR><TD>1</TD><TD>1002</TD><TD>12/05/2020</TD><TD>Normal</TD><TD>2</TD><TD>108</TD></TR><TR><TD>2</TD><TD>1003</TD><TD>12/07/2020</TD><TD>Exceed</TD><TD>2</TD><TD>15</TD></TR></TBODY></TABLE><P> </P><P>and</P><TABLE width="723"><TBODY><TR><TD width="90">Customer</TD><TD width="119">Account</TD><TD width="146">Date</TD><TD width="89">Balance</TD><TD width="128">Status</TD><TD width="151">Days To Back to normal</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>01/04/2020</TD><TD>-100</TD><TD>Exceed</TD><TD> </TD></TR><TR><TD>1</TD><TD>1001</TD><TD>02/04/2020</TD><TD>-150</TD><TD>Exceed</TD><TD> </TD></TR><TR><TD>1</TD><TD>1001</TD><TD>03/04/2020</TD><TD>200</TD><TD>Normal</TD><TD>2</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>20/04/2020</TD><TD>-120</TD><TD>Exceed</TD><TD> </TD></TR><TR><TD>1</TD><TD>1001</TD><TD>10/05/2020</TD><TD>-110</TD><TD>Exceed</TD><TD> </TD></TR><TR><TD>1</TD><TD>1001</TD><TD>05/06/2020</TD><TD>20</TD><TD>Normal</TD><TD>46</TD></TR><TR><TD>1</TD><TD>1001</TD><TD>30/07/2020</TD><TD>-60</TD><TD>Exceed</TD><TD> </TD></TR><TR><TD>1</TD><TD>1002</TD><TD>01/04/2020</TD><TD>180</TD><TD>Normal</TD><TD> </TD></TR><TR><TD>1</TD><TD>1002</TD><TD>10/04/2020</TD><TD>-90</TD><TD>Exceed</TD><TD> </TD></TR><TR><TD>1</TD><TD>1002</TD><TD>30/04/2020</TD><TD>220</TD><TD>Normal</TD><TD>20</TD></TR><TR><TD>1</TD><TD>1002</TD><TD>10/05/2020</TD><TD>230</TD><TD>Normal</TD><TD> </TD></TR><TR><TD>1</TD><TD>1002</TD><TD>12/05/2020</TD><TD>-140</TD><TD>Exceed</TD><TD> </TD></TR><TR><TD>1</TD><TD>1002</TD><TD>08/08/2020</TD><TD>110</TD><TD>Normal</TD><TD>88</TD></TR><TR><TD>2</TD><TD>1003</TD><TD>10/04/2020</TD><TD>290</TD><TD>Normal</TD><TD> </TD></TR><TR><TD>2</TD><TD>1003</TD><TD>15/04/2020</TD><TD>-300</TD><TD>Exceed</TD><TD> </TD></TR><TR><TD>2</TD><TD>1003</TD><TD>30/04/2020</TD><TD>350</TD><TD>Normal</TD><TD>15</TD></TR><TR><TD>2</TD><TD>1003</TD><TD>15/05/2020</TD><TD>320</TD><TD>Normal</TD><TD> </TD></TR><TR><TD>2</TD><TD>1003</TD><TD>12/07/2020</TD><TD>-450</TD><TD>Exceed</TD><TD> </TD></TR><TR><TD>2</TD><TD>1003</TD><TD>02/08/2020</TD><TD>-600</TD><TD>Exceed</TD><TD> </TD></TR></TBODY></TABLE> Tue, 18 Aug 2020 08:05:06 GMT https://community.qlik.com/t5/App-Development/Count-Days-between-Status-changes/m-p/1736637#M56331 ch_riadh 2020-08-18T08:05:06Z