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 ?
