Generate a calendar with begin and end due dates depending the frequency

[Touix]

Hi everyone ! I hope you're doing well.

I have a tricky problematic. I want to verify if a controle is well done during a period of time.

I have this kind of data :

ID  - due date - frequency
1   - 1/2/2022   - Daily
2   - 7/3/2022   - weekly
3   - 12/5/2022  - monthly

I have a controle table too:

ID- controle done
1- 1/2/2022
1-2/2/2022
...
2-9/3/2022
..
3-5/5/2022

The idea is to create a multiple lines with the period of the ID.

Example :

Id - begin due date - end due date 

1-1/2/2022- 1/2/022 
1-2/2/2022-2/2-2022
.....
2-7/3/2022- 13/3/2022
2-14/3/2022-20/3/2022
.....
3-12/5/2022-12/6/2022

The idea is to verify that the controle ID has been correctly done during the period define.

I tried many things in the load script but I don't find something correct.

Thank you all

[Touix · Accepted solution]

Hello Everyone,

I have found the solution. I attach  the Qlikview document if some people need to have a calendar gerate with begin and date date by frequency.