Discussion board where members can get started with QlikView.
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
From which month Your fiscal calendar starts?
Hi try this
SET vFiscalYearStartMonth = 8;
Mod(Month(Date) - $(vFiscalYearStartMonth), 12)+1 AS FiscalMonth,
YearName(Date, 0, $(vFiscalYearStartMonth)) AS FiscalYear;
Its not working,
Its not working
for me it is working fine .Can u please provide sample data so that i can help u
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
So You want to derive Calender Year & Month from Fiscal Period?