topic Re: Fiscal Calendar Problem in QlikView

Fiscal Calendar Problem

Anonymous — Fri, 05 Sep 2014 18:29:36 GMT

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 — Fri, 05 Sep 2014 18:44:37 GMT

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 — Fri, 05 Sep 2014 18:44:48 GMT

try here

Anonymous — Fri, 05 Sep 2014 19:17:00 GMT

Thanks Jonathan,

It's Working