topic Number Of Days Between Two Dates In Same Column in QlikView https://community.qlik.com/t5/QlikView/Number-Of-Days-Between-Two-Dates-In-Same-Column/m-p/150479#M28489 <HTML><HEAD></HEAD><BODY><P>Tks Rainer Filoda but im a newbie, it doesnt work , i have differents Cu_Id<BR />Regards</P></BODY></HTML> Tue, 28 Jul 2009 20:58:05 GMT 2009-07-28T20:58:05Z Number Of Days Between Two Dates In Same Column https://community.qlik.com/t5/QlikView/Number-Of-Days-Between-Two-Dates-In-Same-Column/m-p/150477#M28487 <HTML><HEAD></HEAD><BODY><P>I have to find the number of days between the dates for the same cu_id and add the number as a new column. The new table should look like this.<BR /><BR />Cu_id |Tr_id |Date| Days_between<BR />1234 |1 |12/3/2006 |0<BR />1234 |2 |12/18/2006 |15<BR />1234 |3 |1/5/2007 |18<BR />1234 |4 |1/9/2007 |4</P><P>Thanks!</P><P></P></BODY></HTML> Tue, 28 Jul 2009 20:30:59 GMT https://community.qlik.com/t5/QlikView/Number-Of-Days-Between-Two-Dates-In-Same-Column/m-p/150477#M28487 2009-07-28T20:30:59Z Number Of Days Between Two Dates In Same Column https://community.qlik.com/t5/QlikView/Number-Of-Days-Between-Two-Dates-In-Same-Column/m-p/150478#M28488 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>try <B>Date - Before(Date)</B> for your new column.</P><P>Rainer</P></BODY></HTML> Tue, 28 Jul 2009 20:36:16 GMT https://community.qlik.com/t5/QlikView/Number-Of-Days-Between-Two-Dates-In-Same-Column/m-p/150478#M28488 2009-07-28T20:36:16Z Number Of Days Between Two Dates In Same Column https://community.qlik.com/t5/QlikView/Number-Of-Days-Between-Two-Dates-In-Same-Column/m-p/150479#M28489 <HTML><HEAD></HEAD><BODY><P>Tks Rainer Filoda but im a newbie, it doesnt work , i have differents Cu_Id<BR />Regards</P></BODY></HTML> Tue, 28 Jul 2009 20:58:05 GMT https://community.qlik.com/t5/QlikView/Number-Of-Days-Between-Two-Dates-In-Same-Column/m-p/150479#M28489 2009-07-28T20:58:05Z Number Of Days Between Two Dates In Same Column https://community.qlik.com/t5/QlikView/Number-Of-Days-Between-Two-Dates-In-Same-Column/m-p/150480#M28490 <HTML><HEAD></HEAD><BODY><P>Hi Shariel,</P><P>see the attached example (sorry for the typo: use ABOVE and not BEFORE).</P><P>Be shure that your dat format is correct.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Tue, 28 Jul 2009 21:23:55 GMT https://community.qlik.com/t5/QlikView/Number-Of-Days-Between-Two-Dates-In-Same-Column/m-p/150480#M28490 2009-07-28T21:23:55Z Number Of Days Between Two Dates In Same Column https://community.qlik.com/t5/QlikView/Number-Of-Days-Between-Two-Dates-In-Same-Column/m-p/150481#M28491 <HTML><HEAD></HEAD><BODY><P>it works perfectly</P><P>Thank you very much!</P></BODY></HTML> Tue, 28 Jul 2009 21:33:44 GMT https://community.qlik.com/t5/QlikView/Number-Of-Days-Between-Two-Dates-In-Same-Column/m-p/150481#M28491 2009-07-28T21:33:44Z Number Of Days Between Two Dates In Same Column https://community.qlik.com/t5/QlikView/Number-Of-Days-Between-Two-Dates-In-Same-Column/m-p/150482#M28492 <HTML><HEAD></HEAD><BODY><P>Thank for your help, but I have one more doubt, if I do not have the field <STRONG>Tr_Id</STRONG> could I generate it?</P><P>Regards</P></BODY></HTML> Wed, 29 Jul 2009 02:07:32 GMT https://community.qlik.com/t5/QlikView/Number-Of-Days-Between-Two-Dates-In-Same-Column/m-p/150482#M28492 2009-07-29T02:07:32Z