how to create customized calendar

[Jeff2022]

Dear

We handled contract which subjects our own calendar like below and calculate some contract_end is belong to which new_month.So here's a question.

1,How to make this customized calendar. it's so difficult for me.

Start Date	End Date	New_month	New_Quarter
2021/10/08	2021/11/07	P01	Q1
2021/11/08	2021/12/07	P02	Q1
2021/12/08	2022/01/07	P03	Q1
2022/01/08	2022/02/07	P04	Q2
2022/02/08	2022/03/07	P05	Q2
2022/03/08	2022/04/07	P06	Q2
2022/04/08	2022/05/07	P07	Q3
2022/05/08	2022/06/07	P08	Q3
2022/06/08	2022/07/07	P09	Q3
2022/07/08	2022/08/07	P10	Q4
2022/08/08	2022/09/07	P11	Q4
2022/09/08	2022/10/07	P12	Q4

2, Calculate our contract is belong to which new_month.

Contract_End	New_month
2022-01-27	P04
2022-05-24	P08
2021-12-23	P03
2022-08-06	P10
2022-07-23	P10
2022-07-10	P10
2022-02-23	P05
2021-11-02	P01
2022-02-08	P05
2022-09-07	P11

who can help help? how to make script in qliksense. thank you so much.

Best Regards

Jeff

[paulcalvet]

Hello,

I think you can do that with intervalmatch function:

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptP...

Regards