Calendar Loop

[raceberos]

Hi guys im stuck in with my situation, where i need to create a  table base on start and end date 

ID	Name	StartDate	EndDate
1	Ben	2019-01-15	2019-03-14
2	Ren	2019-03-12	2019-06-11

and the output must be like this

Date	ID	Name	StartDate	EndDate
2019-01-01	1	Ben	2019-01-15	2019-03-14
2019-02-01	1	Ben	2019-01-15	2019-03-14
2019-03-01	1	Ben	2019-01-01	2019-03-14
2019-03-01	2	Ren	2019-03-12	2019-06-11
2019-04-01	2	Ren	2019-03-12	2019-06-11
2019-05-01	2	Ren	2019-03-12	2019-06-11
2019-06-01	2	Ren	2019-03-12	2019-06-11

does anyone have an idea how to handle this kind in qlik sense

Thanks

[Gysbert_Wassenaar]

See this blog post for an example: https://community.qlik.com/t5/Qlik-Design-Blog/Creating-Reference-Dates-for-Intervals/ba-p/1463944

Works in Qlik Sense too.

[raceberos]

thanks bro

[PrashantSangle · Accepted solution]

try below code.

Test_data:
Load * Inline [
ID, Name, StartDate, EndDate
1, Ben, 2019-01-15, 2019-03-14
2, Ren, 2019-03-12, 2019-06-11
];


lood_date:
load distinct
ID as old_ID,
Name as old_Name,
StartDate as old_Start_Date,
EndDate as old_End_Date,
MonthStart(StartDate) as Month_start_date,
MonthStart(EndDate) as Month_end_date,
MonthStart(StartDate,IterNo()-1) as Date
resident Test_data
while AddMonths(StartDate,IterNo()-1) <= MonthStart(EndDate,1);