https://community.qlik.com/t5/QlikView/Count-Days-between-Status/m-p/1735469#M452582 <P>Hi I have this table:</P><TABLE width="513"><TBODY><TR><TD width="56">TRS_NO</TD><TD width="73">SEQUENCE</TD><TD width="87">DATE</TD><TD width="115">AMOUNT</TD><TD width="89">STATUS</TD><TD width="93">AccountNo</TD></TR><TR><TD>101</TD><TD>10011</TD><TD>1/14/2020</TD><TD>1000</TD><TD>POSITIVE</TD><TD>1001</TD></TR><TR><TD>102</TD><TD>10012</TD><TD>1/17/2020</TD><TD>400</TD><TD>NEGATIVE</TD><TD>1001</TD></TR><TR><TD>103</TD><TD>10013</TD><TD>1/22/2020</TD><TD>-1600</TD><TD>POSITIVE</TD><TD>1001</TD></TR><TR><TD>108</TD><TD>10014</TD><TD>1/29/2020</TD><TD>-6600</TD><TD>NEGATIVE</TD><TD>1001</TD></TR><TR><TD><FONT color="#339966">109</FONT></TD><TD><FONT color="#339966">10015</FONT></TD><TD><FONT color="#339966">1/29/2020</FONT></TD><TD><FONT color="#339966">4000</FONT></TD><TD><FONT color="#339966">POSITIVE</FONT></TD><TD><FONT color="#339966">1001</FONT></TD></TR><TR><TD>110</TD><TD>10016</TD><TD>2/15/2020</TD><TD>-10</TD><TD>NEGATIVE</TD><TD>1001</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><FONT color="#339966">If we have 2 change status is same date we should take max(sequence)</FONT></P><P>From 1/14/2020 to&nbsp;1/16/2020 : POSITIVE&nbsp; &nbsp;--&gt;&nbsp; 3 days</P><P>From 1/17/2020 to&nbsp;1/21/2020 : NEGATIVE --&gt; 5 days</P><P>From 1/22/2020 to 2/15/2020 : POSITIVE&nbsp; &nbsp;--&gt;&nbsp; 25 days</P><P>And i want to display a chart ( line, bar&nbsp; ....) any type of chart, like this one:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image0.jpeg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/38943iC8D4BC887CB04225/image-size/large?v=v2&amp;px=999" role="button" title="image0.jpeg" alt="image0.jpeg" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 13 Aug 2020 06:48:07 GMT ch_riadh 2020-08-13T06:48:07Z https://community.qlik.com/t5/QlikView/Count-Days-between-Status/m-p/1735469#M452582 <P>Hi I have this table:</P><TABLE width="513"><TBODY><TR><TD width="56">TRS_NO</TD><TD width="73">SEQUENCE</TD><TD width="87">DATE</TD><TD width="115">AMOUNT</TD><TD width="89">STATUS</TD><TD width="93">AccountNo</TD></TR><TR><TD>101</TD><TD>10011</TD><TD>1/14/2020</TD><TD>1000</TD><TD>POSITIVE</TD><TD>1001</TD></TR><TR><TD>102</TD><TD>10012</TD><TD>1/17/2020</TD><TD>400</TD><TD>NEGATIVE</TD><TD>1001</TD></TR><TR><TD>103</TD><TD>10013</TD><TD>1/22/2020</TD><TD>-1600</TD><TD>POSITIVE</TD><TD>1001</TD></TR><TR><TD>108</TD><TD>10014</TD><TD>1/29/2020</TD><TD>-6600</TD><TD>NEGATIVE</TD><TD>1001</TD></TR><TR><TD><FONT color="#339966">109</FONT></TD><TD><FONT color="#339966">10015</FONT></TD><TD><FONT color="#339966">1/29/2020</FONT></TD><TD><FONT color="#339966">4000</FONT></TD><TD><FONT color="#339966">POSITIVE</FONT></TD><TD><FONT color="#339966">1001</FONT></TD></TR><TR><TD>110</TD><TD>10016</TD><TD>2/15/2020</TD><TD>-10</TD><TD>NEGATIVE</TD><TD>1001</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><FONT color="#339966">If we have 2 change status is same date we should take max(sequence)</FONT></P><P>From 1/14/2020 to&nbsp;1/16/2020 : POSITIVE&nbsp; &nbsp;--&gt;&nbsp; 3 days</P><P>From 1/17/2020 to&nbsp;1/21/2020 : NEGATIVE --&gt; 5 days</P><P>From 1/22/2020 to 2/15/2020 : POSITIVE&nbsp; &nbsp;--&gt;&nbsp; 25 days</P><P>And i want to display a chart ( line, bar&nbsp; ....) any type of chart, like this one:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image0.jpeg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/38943iC8D4BC887CB04225/image-size/large?v=v2&amp;px=999" role="button" title="image0.jpeg" alt="image0.jpeg" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 13 Aug 2020 06:48:07 GMT https://community.qlik.com/t5/QlikView/Count-Days-between-Status/m-p/1735469#M452582 ch_riadh 2020-08-13T06:48:07Z