
Contributor II
2021-11-20
04:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
how to create customized calendar
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
- Tags:
- calendar
589 Views
1 Reply

Partner - Specialist
2021-11-20
04:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
I think you can do that with intervalmatch function:
Regards
573 Views
