How to generate a new table based on a date interval

[#1]

In our employee table we have the following information; employee number, start date and end date. Based on this; how can we generate a new table that includes all dates from start date to end date for each employee.

Employee number	Start date	End date
1000	01.01.2012	10.01.2012
1001	01.04.2013	05.04.2013

How can we generate this table based on the table above?

Employee number	Date
1000	01.01.2012
1000	02.01.2012
1000	03.01.2012
1000	04.01.2012
1000	05.01.2012
1000	06.01.2012
1000	07.01.2012
1000	08.01.2012
1000	09.01.2012
1000	10.01.2012
1001	01.04.2013
1001	02.04.2013
1001	03.04.2013
1001	04.04.2013
1001	05.04.2013

We want to generate this table to link all the dates each employee works for the company to a master calendar.

[kaushiknsolanki · Accepted solution]

Hi,

     Have a look at the IntervalMatch function to do this.

     http://community.qlik.com/docs/DOC-3557

Regards,

Kaushik Solanki

[mdmukramali]

Dear,

Kindly find the attachment.

by using Interval match function we can achieve it.

I hope it will help you.

Thanks,

Mukram.

[#4]

Hi,

Thanks! The Interval Match solved our problem.

Have a nice day.

Regards,

Marte