Discussion Board for collaboration on QlikView Scripting.
If I have a row with a start date of 25/4/2016 and an end date of the 3/5/2016
How would I go about splitting this into calendar days
The output I would like to see is as follows;
Row_ID April-16 May-16 Total
123 5 3 8
I would have thousands of rows of data so would need some kind of loop I would imagine
You could use IntervalMatch to map these data to a calendar.
(StartDate +iterno()-1) as Date
while StartDate +iterno()-1<=EndDate;
In some cases I would only have 7 of the 8 days available to use/select from
How would I get around this?
I did not get you. Can you give example?