topic Re: Distribution of Days among months in QlikView

Distribution of Days among months

upaliwije — Thu, 02 Aug 2018 07:26:15 GMT

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.

Re: Distribution of Days among months

upaliwije — Thu, 02 Aug 2018 12:28:07 GMT

Dear Friends

Can someone suggest me a solution to problem please

Re: Distribution of Days among months

Anonymous — Thu, 02 Aug 2018 13:11:13 GMT

Are you familiar with the function IntervalMatch()?

Re: Distribution of Days among months

upaliwije — Thu, 02 Aug 2018 16:54:56 GMT

If U can develop a smaple doc I can understand

Re: Distribution of Days among months

Anonymous — Fri, 03 Aug 2018 06:48:13 GMT

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

Re: Distribution of Days among months

upaliwije — Fri, 03 Aug 2018 07:40:41 GMT

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

Re: Distribution of Days among months

Anonymous — Fri, 03 Aug 2018 11:18:04 GMT

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

Re: Distribution of Days among months

upaliwije — Wed, 08 Aug 2018 05:36:30 GMT

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

Re: Distribution of Days among months

upaliwije — Wed, 08 Aug 2018 05:44:33 GMT

Dear Friends

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