topic Re: Assign Days to Calendar Month in QlikView

Assign Days to Calendar Month

Fri, 20 May 2016 11:02:00 GMT

Hi there

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

etc

I would have thousands of rows of data so would need some kind of loop I would imagine

Thanks,

Aidan

marcus_sommer — Fri, 20 May 2016 11:04:21 GMT

You could use IntervalMatch to map these data to a calendar.

- Marcus

Kushal_Chawda — Fri, 20 May 2016 11:11:51 GMT

Data:

LOAD Row_ID,

StartDate,

EndDate,

(StartDate +iterno()-1) as Date

FROM table

while StartDate +iterno()-1<=EndDate;

Fri, 20 May 2016 11:19:48 GMT

Thanks Kushal

In some cases I would only have 7 of the 8 days available to use/select from

How would I get around this?

Thanks,

Aidan

Kushal_Chawda — Fri, 20 May 2016 12:38:47 GMT

I did not get you. Can you give example?