Distribution of Days among months

[upaliwije]

Hi Friends

I am faced with a complex task of distribiting no of days across months that fall between two days.  I have attached data in a excel sheet   with required calculation of the output. I want to delevelop this into QV document . Kindly help me to develop QV document with the help of data there and the resulting output.

In my excel sheet Coloumn A-I are source data and column J to AH are output required calculated based on the data given.

[upaliwije]

Dear Friends

Can someone suggest me a solution to problem please

[Anonymous]

Are you familiar with the function IntervalMatch()?

[upaliwije]

If U can develop a smaple doc I can understand

[Anonymous]

Here you can take a look at this: Interval match | Qlik Community

IntervalMatch writes lines of data for every single value between two borders.

Example: startdate 05.05. enddate: 09.05.

IntervalMatch will look like this:

05.05.      ....

06.05.      ....

07.05       ....

08.05.      ....

09.05.      ....

Often you wanna also include the function NetWorkDays() in order to skip saturdays and sundays(if you want to calculate Workdays for a project ect...)

Tell me if you face trouble doing this, I can post an example myself if needed.

greetings,

Fabian

[upaliwije]

Thanks for you advice. I tried and find a little bit difficult. Kindly post asmaple bbased on my data

[Anonymous]

Here is an example:

target_time_table:

Load

       toDate,                    (the value IntervalMatch will use to write down the values inbetween

from xy;

startdueDate_Table:

Load

     dueDate,                    (first border)

     fromDate,                   (second border)

from xy

Results:

NoConcatenate

Load *

resident startdueDate_Table;

drop table startdueDate_Table;

Left Join (Results)

IntervalMatch (toDate)

Load distinct

     fromDate,

     dueDate,

resident startdueDate_Table;

The Result Table should look like this in the end:

fromDate:  dueDate:     toDate:

01.01         04.01.         01.01.

01.01         04.01          02.01

01.01         04.01          03.01

01.01         04.01          04.01

and so on. Hope this helps you out! Sorry I dont have time to go over your source data atm

[upaliwije]

Can one of thr expert help me to develop this QV Doc Please

[upaliwije]

Dear Friends

I have also added the QV doc I have developed upto now . I Need your kind help complete it please.