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

how to convert fiscal Period ID 201506 into date,Month and Year

  Fiscal

KK
14 Replies
Highlighted
Champion III
Champion III

Looks like it is June of 2015:

date(date#(PeriodID,'YYYYMM')) as Date

If you have some special rules for your fiscal calendar, you have to explain these rules

Highlighted
MVP
MVP

From which month Your fiscal calendar starts?

Highlighted
Creator III
Creator III

From August

KK
Highlighted
Not applicable

Hi try this

SET vFiscalYearStartMonth = 8;


load

Mod(Month(Date) - $(vFiscalYearStartMonth), 12)+1 AS FiscalMonth,

YearName(Date, 0, $(vFiscalYearStartMonth)) AS FiscalYear;

resident Abc;

Highlighted
Creator III
Creator III

Its not working,

KK
Highlighted
Creator III
Creator III

Hi Manju,

   Its not working

Regards,

K K

KK
Highlighted
Not applicable

for me it is working fine .Can u please provide sample data so that i can help u

Highlighted
Creator III
Creator III

I am totally agree with your concept but the logic which we are applying is not working on my project Data.

Any ways thanks for your help

KK
Highlighted
MVP
MVP

So You want to derive Calender Year & Month from Fiscal Period?