topic Re: Re: Calculate Date Difference for Various Status against 1 Number in QlikView https://community.qlik.com/t5/QlikView/Calculate-Date-Difference-for-Various-Status-against-1-Number/m-p/482483#M690923 <HTML><HEAD></HEAD><BODY><P>You can try with a reversed order of your rows, so you only set a refdate when there is Approval.</P><P></P><P>I used ROW for reverse sorting your records, but maybe you are using a timestamp with your real data, which would be more appropriate that a plain date value for multiple status entries.</P></BODY></HTML> Wed, 04 Sep 2013 22:11:57 GMT swuehl 2013-09-04T22:11:57Z Calculate Date Difference for Various Status against 1 Number https://community.qlik.com/t5/QlikView/Calculate-Date-Difference-for-Various-Status-against-1-Number/m-p/482479#M690919 <HTML><HEAD></HEAD><BODY><P>Need help on this :</P><P></P><P>I have the data against this Ticket Number :</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 4.8pt; padding: 0 5.4pt;"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: whitesmoke;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><STRONG style="color: #333333; font-size: 8.0pt; font-family: 'Tahoma','sans-serif';">TICKETNUMBER</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: whitesmoke; border-left: none;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><STRONG style="color: #333333; font-size: 8.0pt; font-family: 'Tahoma','sans-serif';">WORKSTATUS</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: whitesmoke; border-left: none;" valign="bottom" width="93"><P style="margin-bottom: 0.0001pt;"><STRONG style="color: #333333; font-size: 8.0pt; font-family: 'Tahoma','sans-serif';">MODIFIEDON</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000304725</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="93"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">10-07-13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000304725</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Customer Approved</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="93"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">11-07-13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000304725</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Customer Approved</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="93"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">11-07-13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000304725</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="93"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">11-07-13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000304725</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="93"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">11-07-13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000304725</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="93"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">24-07-13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000304725</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="93"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">26-07-13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000304725</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Customer Approved</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="93"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">12-08-13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000304725</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="93"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">13-08-13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000304725</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Customer Approved</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="93"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">13-08-13</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>What exactly i need : </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 4.8pt; padding: 0px 5.4pt; width: 592px;"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; background: whitesmoke; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><STRONG style="color: #333333; font-size: 8.0pt; font-family: 'Tahoma','sans-serif';">TICKETNUMBER</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: whitesmoke; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><STRONG style="color: #333333; font-size: 8.0pt; font-family: 'Tahoma','sans-serif';">WORKSTATUS</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: whitesmoke; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="93"><P style="margin-bottom: 0.0001pt;"><STRONG style="color: #333333; font-size: 8.0pt; font-family: 'Tahoma','sans-serif';">MODIFIEDON</STRONG></P></TD><TD nowrap="nowrap" style="border: none; border-right: solid windowtext 1.0pt; background: whitesmoke; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: 0.0001pt;"><STRONG style="color: #333333; font-size: 8.0pt; font-family: 'Tahoma','sans-serif';">Cases to Pick</STRONG></P></TD><TD nowrap="nowrap" style="border: none; border-right: solid windowtext 1.0pt; background: whitesmoke; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="137"><P style="margin-bottom: 0.0001pt;"><STRONG style="color: #333333; font-size: 8.0pt; font-family: 'Tahoma','sans-serif';">Sum (Total)</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000304725</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="93"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">10-07-13</SPAN></P></TD><TD nowrap="nowrap" style="background: yellow; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">Min1</SPAN></P></TD><TD nowrap="nowrap" rowspan="3" style="background: #C5D9F1; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="137"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">Max1-Min1 = <STRONG>1 Day</STRONG></SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000304725</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Customer Approved</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="93"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">11-07-13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000304725</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Customer Approved</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="93"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">11-07-13</SPAN></P></TD><TD nowrap="nowrap" style="background: yellow; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">Max1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000304725</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="93"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">11-07-13</SPAN></P></TD><TD nowrap="nowrap" style="background: #D99795; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">Min2</SPAN></P></TD><TD nowrap="nowrap" rowspan="5" style="background: #C5D9F1; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="137"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">Max2-Min2 = <STRONG>30 Days</STRONG></SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000304725</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="93"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">11-07-13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000304725</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="93"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">24-07-13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000304725</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="93"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">26-07-13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000304725</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Customer Approved</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="93"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">12-08-13</SPAN></P></TD><TD nowrap="nowrap" style="background: #D99795; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">Max2</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000304725</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="93"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">13-08-13</SPAN></P></TD><TD nowrap="nowrap" style="background: #93CDDD; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">Min3</SPAN></P></TD><TD nowrap="nowrap" rowspan="2" style="background: #C5D9F1; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="137"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">Max3 - Min3 = <STRONG>0 Day</STRONG></SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="121"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000304725</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Customer Approved</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="93"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">13-08-13</SPAN></P></TD><TD nowrap="nowrap" style="background: #93CDDD; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">Max3</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="121"><P></P></TD><TD nowrap="nowrap" style="background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P></P></TD><TD nowrap="nowrap" style="background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="93"><P></P></TD><TD nowrap="nowrap" style="background: #C2D69A; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">TOTAL</SPAN></P></TD><TD nowrap="nowrap" style="background: #C2D69A; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="137"><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">1 + 30 + 0 = <STRONG>31 Days</STRONG></SPAN></P></TD></TR></TBODY></TABLE><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 4.8pt; padding: 0px 5.4pt; width: 252px;"><TBODY><TR><TD rowspan="5" style="background: yellow; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="252"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">To Pick Minimum Ticket Number and Maximum Creation date not only once but number of times if Multiple status appear against same Ticket Number <BR /></SPAN></P></TD></TR><TR></TR><TR></TR></TBODY></TABLE></BODY></HTML> Wed, 04 Sep 2013 18:00:38 GMT https://community.qlik.com/t5/QlikView/Calculate-Date-Difference-for-Various-Status-against-1-Number/m-p/482479#M690919 aveeeeeee7en 2013-09-04T18:00:38Z Re: Calculate Date Difference for Various Status against 1 Number https://community.qlik.com/t5/QlikView/Calculate-Date-Difference-for-Various-Status-against-1-Number/m-p/482480#M690920 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Wed, 04 Sep 2013 18:38:51 GMT https://community.qlik.com/t5/QlikView/Calculate-Date-Difference-for-Various-Status-against-1-Number/m-p/482480#M690920 Gysbert_Wassenaar 2013-09-04T18:38:51Z Re: Calculate Date Difference for Various Status against 1 Number https://community.qlik.com/t5/QlikView/Calculate-Date-Difference-for-Various-Status-against-1-Number/m-p/482481#M690921 <HTML><HEAD></HEAD><BODY><P>Thank You very much <SPAN class="j-post-author"><STRONG><A href="https://community.qlik.com/people/gwassenaar">gwassenaar</A></STRONG></SPAN></P><P><SPAN class="j-post-author"><STRONG>Your Logic works. Short and Effective. Gr8.<BR /></STRONG></SPAN></P><P><SPAN class="j-post-author"><STRONG>You resolved my issue.<BR /></STRONG></SPAN></P></BODY></HTML> Wed, 04 Sep 2013 19:19:00 GMT https://community.qlik.com/t5/QlikView/Calculate-Date-Difference-for-Various-Status-against-1-Number/m-p/482481#M690921 aveeeeeee7en 2013-09-04T19:19:00Z Re: Calculate Date Difference for Various Status against 1 Number https://community.qlik.com/t5/QlikView/Calculate-Date-Difference-for-Various-Status-against-1-Number/m-p/482482#M690922 <HTML><HEAD></HEAD><BODY><P>There are some lag in the logic.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 4.8pt; padding: 0px 5.4pt; width: 541px;"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; background: whitesmoke; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="51"><P style="margin-bottom: .0001pt;"><STRONG style="color: #333333; font-size: 8.0pt; font-family: 'Tahoma','sans-serif';">ROW</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: whitesmoke; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><STRONG style="color: #333333; font-size: 8.0pt; font-family: 'Tahoma','sans-serif';">TICKETNUMBER</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: whitesmoke; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="189"><P style="margin-bottom: .0001pt;"><STRONG style="color: #333333; font-size: 8.0pt; font-family: 'Tahoma','sans-serif';">WORKSTATUS</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: whitesmoke; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="92"><P style="margin-bottom: .0001pt;"><STRONG style="color: #333333; font-size: 8.0pt; font-family: 'Tahoma','sans-serif';">MODIFIEDON</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: whitesmoke; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="75"><P style="margin-bottom: .0001pt;"><STRONG style="color: #333333; font-size: 8.0pt; font-family: 'Tahoma','sans-serif';">REFDATE</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="51"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">39457</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: yellow; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="189"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="92"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">29/05/13</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="75"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">29/05/13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="51"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">39450</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: yellow; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="189"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="92"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">30/05/13</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="75"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">29/05/13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="51"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">40138</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: yellow; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="189"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="92"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">03/06/13</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="75"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">29/05/13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="51"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">4630</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: yellow; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="189"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Customer Approved</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="92"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">05/06/13</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="75"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">29/05/13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="51"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">373</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="189"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="92"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">17/06/13</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="75"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">17/06/13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="51"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">2603</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="189"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="92"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">17/06/13</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="75"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">17/06/13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="51"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">5373</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="189"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="92"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">19/06/13</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="75"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">17/06/13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="51"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">6326</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="189"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="92"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">22/06/13</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="75"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">17/06/13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="51"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">7144</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="189"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="92"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">26/06/13</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="75"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">17/06/13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="51"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">6948</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="189"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="92"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">01/07/13</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="75"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">17/06/13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="51"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">3528</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="189"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="92"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">04/07/13</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="75"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">17/06/13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="51"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">7666</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="189"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="92"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">09/07/13</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="75"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">17/06/13</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>For above case it should calculate only the Highlighted data but it is Calculating others also.</P><P>Since i need both Pending for Customer Approval and Customer Approval if they both are coming so pick max and min dates.</P><P>Highlighted data is correct since it has both Pending for customer approval and Customer Approved Dates but below after this there are Pending for Customer Approval multiple cases but there is no Customer Approval Status. So. we dont want to need these dates. But According to you Calculation it is calculating its difference also.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 4.8pt; padding: 0 5.4pt 0 5.4pt;" width="223"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; background: whitesmoke; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="111"><P style="margin-bottom: .0001pt;"><STRONG style="color: #333333; font-size: 8.0pt; font-family: 'Tahoma','sans-serif';">TICKETNUMBER</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: whitesmoke; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="112"><P style="margin-bottom: .0001pt;"><STRONG style="color: #333333; font-size: 8.0pt; font-family: 'Tahoma','sans-serif';">max(MODIFIEDON)-only(REFDATE)</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: whitesmoke; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="111"><P style="margin-bottom: .0001pt;"><STRONG> </STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: whitesmoke; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="112"><OL style="list-style-type: decimal;"><LI><STRONG style="color: black; font-size: 8.0pt; font-family: 'Tahoma','sans-serif';">28.74</STRONG></LI></OL></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="111"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="112"><OL style="list-style-type: decimal;"><LI><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">6.81</SPAN></LI></OL></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="111"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="112"><OL style="list-style-type: decimal;"><LI><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">21.93</SPAN></LI></OL></TD></TR></TBODY></TABLE><P></P><P>Here the data should be 6.81 only. 21.93 not to be count.</P></BODY></HTML> Wed, 04 Sep 2013 19:53:23 GMT https://community.qlik.com/t5/QlikView/Calculate-Date-Difference-for-Various-Status-against-1-Number/m-p/482482#M690922 aveeeeeee7en 2013-09-04T19:53:23Z Re: Re: Calculate Date Difference for Various Status against 1 Number https://community.qlik.com/t5/QlikView/Calculate-Date-Difference-for-Various-Status-against-1-Number/m-p/482483#M690923 <HTML><HEAD></HEAD><BODY><P>You can try with a reversed order of your rows, so you only set a refdate when there is Approval.</P><P></P><P>I used ROW for reverse sorting your records, but maybe you are using a timestamp with your real data, which would be more appropriate that a plain date value for multiple status entries.</P></BODY></HTML> Wed, 04 Sep 2013 22:11:57 GMT https://community.qlik.com/t5/QlikView/Calculate-Date-Difference-for-Various-Status-against-1-Number/m-p/482483#M690923 swuehl 2013-09-04T22:11:57Z Re: Calculate Date Difference for Various Status against 1 Number https://community.qlik.com/t5/QlikView/Calculate-Date-Difference-for-Various-Status-against-1-Number/m-p/482484#M690924 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 4.8pt; padding: 0 5.4pt;"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: whitesmoke;" valign="bottom" width="99"><P style="margin-bottom: .0001pt;"><STRONG style="color: #333333; font-size: 8.0pt; font-family: 'Tahoma','sans-serif';">TICKETNUMBER</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: whitesmoke; border-left: none;" valign="bottom" width="155"><P style="margin-bottom: .0001pt;"><STRONG style="color: #333333; font-size: 8.0pt; font-family: 'Tahoma','sans-serif';">WORKSTATUS</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: whitesmoke; border-left: none;" valign="top" width="77"><P style="margin-bottom: .0001pt;"><STRONG style="color: #333333; font-size: 8.0pt; font-family: 'Tahoma','sans-serif';">MODIFIEDON</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; border-left: none;" valign="bottom" width="131"><P></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; border-left: none;" valign="top" width="56"><P></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; border-left: none;" valign="bottom" width="93"><P></P></TD><TD rowspan="5" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; border-left: none;" valign="bottom" width="64"><OL style="list-style-type: decimal;"><LI><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">11.85318</SPAN></LI></OL></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="99"><SPAN style="color: #333333; font-size: 8.0pt; margin-bottom: .0001pt; font-family: 'Tahoma','sans-serif';">CD1300000292734</SPAN></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: yellow; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="155"><SPAN style="color: #333333; font-size: 8.0pt; margin-bottom: .0001pt; font-family: 'Tahoma','sans-serif';">Pending for Customer Approval</SPAN></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="77"><SPAN style="color: #333333; font-size: 8.0pt; margin-bottom: .0001pt; font-family: 'Tahoma','sans-serif';">20/05/13</SPAN></TD><TD nowrap="nowrap" rowspan="3" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="131"><SPAN style="text-align: center; font-size: 10.0pt; margin-bottom: .0001pt; font-family: 'Arial','sans-serif';">Pick Minimum Date</SPAN></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="56"><SPAN style="color: #333333; font-size: 8.0pt; margin-bottom: .0001pt; font-family: 'Tahoma','sans-serif';">20/05/13</SPAN></TD><TD rowspan="4" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="93"><SPAN style="text-align: center; font-size: 10.0pt; margin-bottom: .0001pt; font-family: 'Arial','sans-serif';">Maximum Date - Minimum Date</SPAN></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="99"><SPAN style="color: #333333; font-size: 8.0pt; margin-bottom: .0001pt; font-family: 'Tahoma','sans-serif';">CD1300000292734</SPAN></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: yellow; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="155"><SPAN style="color: #333333; font-size: 8.0pt; margin-bottom: .0001pt; font-family: 'Tahoma','sans-serif';">Pending for Customer Approval</SPAN></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="77"><SPAN style="color: #333333; font-size: 8.0pt; margin-bottom: .0001pt; font-family: 'Tahoma','sans-serif';">21/05/13</SPAN></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="56"> </TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="99"><SPAN style="color: #333333; font-size: 8.0pt; margin-bottom: .0001pt; font-family: 'Tahoma','sans-serif';">CD1300000292734</SPAN></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: yellow; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="155"><SPAN style="color: #333333; font-size: 8.0pt; margin-bottom: .0001pt; font-family: 'Tahoma','sans-serif';">Pending for Customer Approval</SPAN></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="77"><SPAN style="color: #333333; font-size: 8.0pt; margin-bottom: .0001pt; font-family: 'Tahoma','sans-serif';">23/06/13</SPAN></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="56"> </TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="99"><SPAN style="color: #333333; font-size: 8.0pt; margin-bottom: .0001pt; font-family: 'Tahoma','sans-serif';">CD1300000292734</SPAN></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: #B8CCE4; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="155"><SPAN style="color: #333333; font-size: 8.0pt; margin-bottom: .0001pt; font-family: 'Tahoma','sans-serif';">Customer Approved</SPAN></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="77"><SPAN style="color: #333333; font-size: 8.0pt; margin-bottom: .0001pt; font-family: 'Tahoma','sans-serif';">01/06/13</SPAN></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="131"><SPAN style="font-size: 10.0pt; margin-bottom: .0001pt; font-family: 'Arial','sans-serif';">Pick Maximum Date</SPAN></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="56"><SPAN style="color: #333333; font-size: 8.0pt; margin-bottom: .0001pt; font-family: 'Tahoma','sans-serif';">01/06/13</SPAN></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="99"><SPAN style="color: #333333; font-size: 8.0pt; margin-bottom: .0001pt; font-family: 'Tahoma','sans-serif';">CD1300000292734</SPAN></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: yellow; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="155"><SPAN style="color: #333333; font-size: 8.0pt; margin-bottom: .0001pt; font-family: 'Tahoma','sans-serif';">Pending for Customer Approval</SPAN></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="77"><SPAN style="color: #333333; font-size: 8.0pt; margin-bottom: .0001pt; font-family: 'Tahoma','sans-serif';">29/05/13</SPAN></TD><TD nowrap="nowrap" rowspan="3" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="131"><SPAN style="text-align: center; font-size: 10.0pt; margin-bottom: .0001pt; font-family: 'Arial','sans-serif';">Pick Minimum Date1</SPAN></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="56"><SPAN style="color: #333333; font-size: 8.0pt; margin-bottom: .0001pt; font-family: 'Tahoma','sans-serif';">29/05/13</SPAN></TD><TD rowspan="5" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="93"><SPAN style="text-align: center; font-size: 10.0pt; margin-bottom: .0001pt; font-family: 'Arial','sans-serif';">Maximum Date1 - Minimum Date1</SPAN></TD><TD nowrap="nowrap" rowspan="5" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="64"><OL style="list-style-type: decimal;"><LI><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">6.8136</SPAN></LI></OL></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="99"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: yellow; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="155"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="77"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">30/05/13</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="56"><P></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="99"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: yellow; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="155"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="77"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">03/06/13</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="56"><P></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="99"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: #B8CCE4; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="155"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Customer Approved</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="77"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">03/06/13</SPAN></P></TD><TD nowrap="nowrap" rowspan="2" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="131"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">Pick Maximum Date1</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="56"><P></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="99"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: #B8CCE4; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="155"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Customer Approved</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="77"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">05/06/13</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="56"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">05/06/13</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="99"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: #93CDDD; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="155"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="77"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">17/06/13</SPAN></P></TD><TD rowspan="8" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="131"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">Not to be used since after 'Pending for Customer Approval' there is no 'Customer Approval'. So, I don’t have to consider these cases. </SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="56"><P></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="93"><P></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="64"><P></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="99"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: #93CDDD; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="155"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="77"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">17/06/13</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="56"><P></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="93"><P></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="64"><P></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="99"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: #93CDDD; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="155"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="77"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">19/06/13</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="56"><P></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="93"><P></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="64"><P></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="99"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: #93CDDD; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="155"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="77"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">22/06/13</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="56"><P></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="93"><P></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="64"><P></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="99"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: #93CDDD; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="155"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="77"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">26/06/13</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="56"><P></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="93"><P></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="64"><P></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="99"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: #93CDDD; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="155"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="77"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">01/07/13</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="56"><P></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="93"><P></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="64"><P></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="99"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: #93CDDD; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="155"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="77"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">04/07/13</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="56"><P></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="93"><P></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="64"><P></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; background: white; border-top: none;" valign="bottom" width="99"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">CD1300000292734</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: #93CDDD; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="155"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Pending for Customer Approval</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; background: white; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="77"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">09/07/13</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="56"><P></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="93"><P></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="64"><P></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; border-top: none;" valign="bottom" width="99"><P></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="155"><P></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="77"><P></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="131"><P></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="top" width="56"><P></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="93"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">Total</SPAN></P></TD><TD nowrap="nowrap" style="border: 0px solid black; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" valign="bottom" width="64"><OL style="list-style-type: decimal;"><LI><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">18.6667</SPAN></LI></OL></TD></TR></TBODY></TABLE><P></P><P></P><P>Need help on the above example.</P></BODY></HTML> Sat, 07 Sep 2013 21:48:18 GMT https://community.qlik.com/t5/QlikView/Calculate-Date-Difference-for-Various-Status-against-1-Number/m-p/482484#M690924 aveeeeeee7en 2013-09-07T21:48:18Z