topic How to generate a new table based on a date interval in QlikView

How to generate a new table based on a date interval

Tue, 12 Nov 2013 11:19:31 GMT

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.

Re: How to generate a new table based on a date interval

kaushiknsolanki — Tue, 12 Nov 2013 11:21:26 GMT

Hi,

Have a look at the IntervalMatch function to do this.

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

Regards,

Kaushik Solanki

Re: How to generate a new table based on a date interval

mdmukramali — Tue, 12 Nov 2013 12:53:33 GMT

Dear,

Kindly find the attachment.

by using Interval match function we can achieve it.

I hope it will help you.

Thanks,

Mukram.

Re: How to generate a new table based on a date interval

Tue, 12 Nov 2013 13:28:19 GMT

Hi,

Thanks! The Interval Match solved our problem.

Have a nice day.

Regards,

Marte