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

Touix — Tue, 28 Jun 2022 13:04:24 GMT

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

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

Touix — Thu, 30 Jun 2022 06:48:10 GMT

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.

topic Re: Generate a calendar with begin and end due dates depending the frequency in App Development

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

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