Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Some trouble counting days

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