Discussion board where members can get started with QlikView.
Date(Date#(Fiscal_Year & Fiscal_Week,'YYYYWW'),'YYYYWW') as YearWeek
I understand now that YYYYWW is now Year & Weekday and not Week#.
Is there a way to convert Fiscal Year and Week to YYYYWW as in Week?
How about this
Fiscal_Year*100 + Fiscal_Week as YearWeek
Left(Fiscal_Year,4) & Fiscal_Week as YearWeek
Or may be
Date(Date#(Left(Fiscal_Year,4),'YYYY'),'YYYY') & Fiscal_Week as YearWeek
Year(Date#(Left(Fiscal_Year,4),'YYYY')) & Fiscal_Week as YearWeek