topic How to calculate Date Difference... in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-Date-Difference/m-p/989746#M956520 <HTML><HEAD></HEAD><BODY><P>hello all,</P><P>i would like to display my date in the following manner can anyone know how to do that...</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="308" style="width: 806px; height: 108px;"><TBODY><TR><TD class="xl66" height="21" width="64">Company Name</TD><TD class="xl66" style="border-left: none;" width="90">Location</TD><TD class="xl66" style="border-left: none;" width="71">0-15 days</TD><TD class="xl66" style="border-left: none;" width="64">&nbsp; 16-30 days</TD><TD class="xl66" style="border-left: none;" width="64">31-40 days</TD><TD class="xl66" style="border-left: none;" width="79">41-60 days</TD><TD class="xl66" style="border-left: none;" width="79">61-90 days</TD><TD class="xl66" style="border-left: none;" width="87">91-180 days</TD><TD class="xl66" style="border-left: none;" width="96">181-360 days</TD><TD class="xl66" style="border-left: none;" width="115">Above 360 days</TD><TD class="xl66" style="border-left: none;" width="88">Grand Total</TD></TR><TR><TD class="xl67" height="21" style="border-top: none;">a</TD><TD class="xl67" style="border-top: none; border-left: none;">ABC</TD><TD class="xl68" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl68" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.24 </TD><TD class="xl68" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.08 </TD><TD class="xl69" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl69" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl69" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl69" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl69" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl68" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.32 </TD></TR><TR><TD class="xl67" height="21" style="border-top: none;">b</TD><TD class="xl67" style="border-top: none; border-left: none;">RON</TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.06 </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.15 </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.21 </TD></TR><TR><TD class="xl67" height="21" style="border-top: none;">c</TD><TD class="xl67" style="border-top: none; border-left: none;">T.N</TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.03 </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.18 </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.21 </TD></TR><TR><TD class="xl67" height="21" style="border-top: none;">d</TD><TD class="xl67" style="border-top: none; border-left: none;">T.N</TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.16 </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.02 </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.19 </TD></TR><TR><TD class="xl67" height="21" style="border-top: none;">e</TD><TD class="xl67" style="border-top: none; border-left: none;">A.P</TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.14 </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.05 </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.19 </TD></TR><TR><TD class="xl67" height="21" style="border-top: none;">f</TD><TD class="xl67" style="border-top: none; border-left: none;">XYZ</TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.12 </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.05 </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.17 </TD></TR></TBODY></TABLE></BODY></HTML> Fri, 13 Nov 2015 05:41:37 GMT hamzabob1 2015-11-13T05:41:37Z How to calculate Date Difference... https://community.qlik.com/t5/QlikView/How-to-calculate-Date-Difference/m-p/989746#M956520 <HTML><HEAD></HEAD><BODY><P>hello all,</P><P>i would like to display my date in the following manner can anyone know how to do that...</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="308" style="width: 806px; height: 108px;"><TBODY><TR><TD class="xl66" height="21" width="64">Company Name</TD><TD class="xl66" style="border-left: none;" width="90">Location</TD><TD class="xl66" style="border-left: none;" width="71">0-15 days</TD><TD class="xl66" style="border-left: none;" width="64">&nbsp; 16-30 days</TD><TD class="xl66" style="border-left: none;" width="64">31-40 days</TD><TD class="xl66" style="border-left: none;" width="79">41-60 days</TD><TD class="xl66" style="border-left: none;" width="79">61-90 days</TD><TD class="xl66" style="border-left: none;" width="87">91-180 days</TD><TD class="xl66" style="border-left: none;" width="96">181-360 days</TD><TD class="xl66" style="border-left: none;" width="115">Above 360 days</TD><TD class="xl66" style="border-left: none;" width="88">Grand Total</TD></TR><TR><TD class="xl67" height="21" style="border-top: none;">a</TD><TD class="xl67" style="border-top: none; border-left: none;">ABC</TD><TD class="xl68" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl68" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.24 </TD><TD class="xl68" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.08 </TD><TD class="xl69" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl69" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl69" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl69" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl69" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl68" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.32 </TD></TR><TR><TD class="xl67" height="21" style="border-top: none;">b</TD><TD class="xl67" style="border-top: none; border-left: none;">RON</TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.06 </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.15 </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.21 </TD></TR><TR><TD class="xl67" height="21" style="border-top: none;">c</TD><TD class="xl67" style="border-top: none; border-left: none;">T.N</TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.03 </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.18 </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.21 </TD></TR><TR><TD class="xl67" height="21" style="border-top: none;">d</TD><TD class="xl67" style="border-top: none; border-left: none;">T.N</TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.16 </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.02 </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.19 </TD></TR><TR><TD class="xl67" height="21" style="border-top: none;">e</TD><TD class="xl67" style="border-top: none; border-left: none;">A.P</TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.14 </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.05 </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.19 </TD></TR><TR><TD class="xl67" height="21" style="border-top: none;">f</TD><TD class="xl67" style="border-top: none; border-left: none;">XYZ</TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.12 </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.05 </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl71" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp; </TD><TD class="xl70" style="border-top: none; border-left: none;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.17 </TD></TR></TBODY></TABLE></BODY></HTML> Fri, 13 Nov 2015 05:41:37 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Date-Difference/m-p/989746#M956520 hamzabob1 2015-11-13T05:41:37Z Re: How to calculate Date Difference... https://community.qlik.com/t5/QlikView/How-to-calculate-Date-Difference/m-p/989747#M956521 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>See</P><P><A href="https://community.qlik.com/qlik-blogpost/3821">Buckets</A></P><P></P><P> It will help your.</P><P></P><P>Regards</P></BODY></HTML> Fri, 13 Nov 2015 07:15:10 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Date-Difference/m-p/989747#M956521 PrashantSangle 2015-11-13T07:15:10Z Re: How to calculate Date Difference... https://community.qlik.com/t5/QlikView/How-to-calculate-Date-Difference/m-p/989748#M956522 <HTML><HEAD></HEAD><BODY><P>see these threads:</P><P></P><P><A href="https://community.qlik.com/thread/119623">Creating Aging Buckets within QlikView</A></P><P></P><P><A href="https://community.qlik.com/thread/74808">Creating Buckets in the Load Script</A></P></BODY></HTML> Fri, 13 Nov 2015 07:26:37 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Date-Difference/m-p/989748#M956522 Anonymous 2015-11-13T07:26:37Z Re: How to calculate Date Difference... https://community.qlik.com/t5/QlikView/How-to-calculate-Date-Difference/m-p/989749#M956523 <HTML><HEAD></HEAD><BODY><P>wowwww..thank you all</P></BODY></HTML> Fri, 13 Nov 2015 08:41:59 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Date-Difference/m-p/989749#M956523 hamzabob1 2015-11-13T08:41:59Z