topic Some trouble counting days in QlikView https://community.qlik.com/t5/QlikView/Some-trouble-counting-days/m-p/321881#M1196952 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>New to Qlikview I have already discovered a few areas but I am stuck with a date question. </P><P></P><P>I have a file with events having a start date and and end date. I would like to calculate the number of days included between those two dates but per month.</P><P>For example :</P><P>Start date : 15 january 2011</P><P>End date : 15 March 2011</P><P></P><P>The result would be :</P><P>January 16 days</P><P>February 28 days</P><P>March 15 days</P><P>April 0 days </P><P></P><P>And so on.</P><P></P><P></P><P>I have found the Interval function that counts the number of days between two dates, but how can I split this in a per month basis ?</P><P></P><P>Thank you for your help.</P><P></P><P>Allain</P></BODY></HTML> Tue, 24 May 2011 08:47:24 GMT 2011-05-24T08:47:24Z Some trouble counting days https://community.qlik.com/t5/QlikView/Some-trouble-counting-days/m-p/321881#M1196952 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>New to Qlikview I have already discovered a few areas but I am stuck with a date question. </P><P></P><P>I have a file with events having a start date and and end date. I would like to calculate the number of days included between those two dates but per month.</P><P>For example :</P><P>Start date : 15 january 2011</P><P>End date : 15 March 2011</P><P></P><P>The result would be :</P><P>January 16 days</P><P>February 28 days</P><P>March 15 days</P><P>April 0 days </P><P></P><P>And so on.</P><P></P><P></P><P>I have found the Interval function that counts the number of days between two dates, but how can I split this in a per month basis ?</P><P></P><P>Thank you for your help.</P><P></P><P>Allain</P></BODY></HTML> Tue, 24 May 2011 08:47:24 GMT https://community.qlik.com/t5/QlikView/Some-trouble-counting-days/m-p/321881#M1196952 2011-05-24T08:47:24Z