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
