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

    Some trouble counting days

    Alain NICALEK



      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.