Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Fiscal Year and Fiscal Week converted to Fiscal Year Week

MapDateToFiscalWeek:

Mapping

LOAD Date,

    Date(Date#(Fiscal_Year & Fiscal_Week,'YYYYWW'),'YYYYWW') as YearWeek

FROM

[$(vQVDs)\T_Calendar_Test.qvd](qvd);

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?         

3 Replies
Highlighted

How about this

Fiscal_Year*100 + Fiscal_Week as YearWeek

Highlighted

Try this

Left(Fiscal_Year,4) & Fiscal_Week as YearWeek

Highlighted

Or may be


Date(Date#(Left(Fiscal_Year,4),'YYYY'),'YYYY') & Fiscal_Week as YearWeek


Or


Year(Date#(Left(Fiscal_Year,4),'YYYY')) & Fiscal_Week as YearWeek