topic Fiscal Year Issue in QlikView

Fiscal Year Issue

vanderson009 — Thu, 14 Nov 2013 12:03:12 GMT

I have Purchase Date. On Purchase Date i need to create Fiscal Calender.

And my Fiscal Calender is

If any knows how to do this then please Help me.

Thanks and Regards,

Anderson

er_mohit — Thu, 14 Nov 2013 12:09:56 GMT

Try this in script

if(num(month(Date))>=1 and num(month(Date))<=3,'Q3',

if(num(month(Date))>=4 and num(month(Date))<=6,'Q4',

if(num(month(Date))>=7 and num(month(Date))<=9,'Q1',

if(num(month(Date))>=10 and num(month(Date))<=12,'Q2')))) as

FinancialQuarter

kaushiknsolanki — Thu, 14 Nov 2013 12:27:35 GMT

Hi,

Let vMin = num(MakeDate(2010,07,01));

Let vMax = num(Today());

Date:

Load

Date($(vMin) + RowNo() -1) as DATE

AutoGenerate 1

While Date($(vMin) + RowNo() -1) < Date($(vMax));

MasterCal:

LOad DATE,

Month(DATE) as MONTH,

Year(DATE) as CAL_YEAR,

If(Num(Month(DATE)) >6 ,Year(DATE)+1,YEar(DATE)) as FIS_YEAR,

'Q'& if(ceil(num(Month(DATE))/3)<=2,ceil(num(Month(DATE))/3)+2,ceil(num(Month(DATE))/3)-2) as _FIS_Quarter

Resident Date;

Regards,

Kaushik Solanki

hic — Fri, 15 Nov 2013 09:05:54 GMT

I would use a variable for first month of fiscal year and then define my fields based on this variable. See more on

HIC