I have been trying to setup fiscal week in Qliksense according to my company's layout. For 2018, we have a 4,4,5 layout for each quarter (4 weeks, 4 weeks, 5 weeks). I am trying to represent that as a date dimension. I have seen the fiscal calendar post Fiscal Calendar with Non-Standard Days (Not 1-31), but I believe I am still missing a piece as the start date for each fiscal month is a different date. the first quarter for 2018 would go Dec 31 2017- Jan 27 2018, Jan 28 - Feb 24, Feb 25 - Mar 31.
We have created this in excel to represent the calendar, but I am finding it difficult to translate in this system to make it functional:
Function Create_Week_String(Yesterday As Date) As String