Hi Qlik community!
First of all, I have learned a ton from all of you and I am thankful for all of the great posts!
Would be completely lost without these discussions/questions/answers.
Time for my 1st question!
Due to the sensitive nature of the dataset, I cannot share the QVW.
I can, however, post the script.
1) I want the calendar to show partial fiscal weeks by splitting weeks that overlap quarters.
2) We were not provided fiscal week level estimates, but would like to calculate them via the following logic:
I have left out the tabs where I set filepaths and do mappings.
See attached Word doc.
Thank you, I look forward to learning and hearing your responses!!!