Fiscal Calendar Problem

[Anonymous]

Hi,

we have to follow calendar April-March and We have a field 'OrderDate', Based on this field how can i derive the year?

for eg:

For the period April-01-2014 to March-31-2015 we need to show year as 2014.

[JonnyPoole · Accepted solution]

It will be worth calculating some new fiscal period fields in your load script.

Here are a few examples that take a field called 'Date' and calculate a FiscalYear,FiscalMonthNumber,FiscalYearMonth etc...

LOAD

     Date,

     if( Month(Date)>=4, Year(Date), Year(Date) -1) as FiscalYear,

     if( Month(Date)>=4, Month(Date)-3,Month(Date)+9) as FiscalMonthNumber,

     if( Month(Date)>=4, Year(Date), Year(Date) -1) & ' - ' & if( Month(Date)>=4, Month(Date)-3,Month(Date)+9) as FiscalYearMonth,

     Year(Date) & ' - ' & Month(Date) as CalendarYearMonth

FROM

<source>;

here is the sample app for you to look at .

[maxgro]

try here

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year

[Anonymous]

Thanks Jonathan,

It's Working