Month Breakdown with loops

Fri, 13 Feb 2015 15:36:18 GMT

Hi. I was wondering if it was possible to split up the number of days per month between 2 dates using something like a while loop. My initial thought was that you could create a max and min date then maybe use some inner loops for breaking that up.

Say you start off with this.

Then you might get to something like this with a unique reference, although there will probably be more than one year so Unique month would have +12 for 2014, +24 for 2015 etc.

And then add the days of the month so to finish like this.

N.B it does not always start from the 1st of the month.

Is this possible or is there no function that would incorporate months in this way?

Thanks for your time.

Oli

topic Month Breakdown with loops in QlikView

Month Breakdown with loops