topic Re: How To calculate days difference between one date field in QlikView https://community.qlik.com/t5/QlikView/How-To-calculate-days-difference-between-one-date-field/m-p/381344#M142277 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>It is possible, but depends on the real data set.</P><P>If you have only 1 date per status per id and only few states per id you can use set analysis (see the example attached).</P><P></P><P>Regards,</P><P>David</P></BODY></HTML> Tue, 28 Aug 2012 06:42:28 GMT daveamz 2012-08-28T06:42:28Z How To calculate days difference between one date field https://community.qlik.com/t5/QlikView/How-To-calculate-days-difference-between-one-date-field/m-p/381343#M142276 <HTML><HEAD></HEAD><BODY><P>My Input file is like this :</P><P></P><P></P><P>Id&nbsp;&nbsp; Status&nbsp;&nbsp; Date</P><P>101&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; 1-8-2012</P><P>101&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp; 10-8-2012</P><P>101&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15 -8-2012</P><P>101&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25-8-2012</P><P>102&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3-8-2012</P><P>102&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16-8-2012</P><P></P><P></P><P>My out put is like this :</P><P></P><P>Id&nbsp;&nbsp;&nbsp; Days(days difference between status 2 - status 1)&nbsp;&nbsp; Days(days difference between status 3 - status 2)&nbsp;&nbsp; </P><P>101&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9 days&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5 days</P><P>102&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13 days&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ---</P><P></P><P></P><P>It is possible to qlikview</P></BODY></HTML> Tue, 28 Aug 2012 06:23:47 GMT https://community.qlik.com/t5/QlikView/How-To-calculate-days-difference-between-one-date-field/m-p/381343#M142276 2012-08-28T06:23:47Z Re: How To calculate days difference between one date field https://community.qlik.com/t5/QlikView/How-To-calculate-days-difference-between-one-date-field/m-p/381344#M142277 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>It is possible, but depends on the real data set.</P><P>If you have only 1 date per status per id and only few states per id you can use set analysis (see the example attached).</P><P></P><P>Regards,</P><P>David</P></BODY></HTML> Tue, 28 Aug 2012 06:42:28 GMT https://community.qlik.com/t5/QlikView/How-To-calculate-days-difference-between-one-date-field/m-p/381344#M142277 daveamz 2012-08-28T06:42:28Z Re: How To calculate days difference between one date field https://community.qlik.com/t5/QlikView/How-To-calculate-days-difference-between-one-date-field/m-p/381345#M142278 <HTML><HEAD></HEAD><BODY><P>Thanx Dave</P><P></P><P>Its Working</P></BODY></HTML> Tue, 28 Aug 2012 06:57:32 GMT https://community.qlik.com/t5/QlikView/How-To-calculate-days-difference-between-one-date-field/m-p/381345#M142278 2012-08-28T06:57:32Z