0 Replies Latest reply: May 24, 2011 4:48 AM by Alain NICALEK RSS

    Some trouble counting days

    Alain NICALEK

      Hello,

       

      New to Qlikview I have already discovered a few areas but I am stuck with a date question.

       

      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.

      For example :

      Start date : 15 january 2011

      End date : 15 March 2011

       

      The result would be :

      January 16 days

      February 28 days

      March 15 days

      April 0 days

       

      And so on.

       

       

      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 ?

       

      Thank you for your help.

       

      Allain