Fiscal

[#1]

Hey guys

I got a set of dates here but the customer would like it as a fiscal calender starting from 1July-30June. It needs to be set up as default for the whle document without using a calender object.

can anyone please instruct me on how to go about dong this?

Any help is much appreciated.

Thanks

[#2 · Accepted solution]

So use the following script to make the startdate into fiscal year from Jul-Jun.....

LOAD
BusinessEntityID,
TerritoryID,
StartDate,
yearname (StartDate, 0, 7) as FiscalYear,
EndDate;

[#3]

thanks for explaining it. much appreciated

[#4]

Hi carneyfm,

We have the almost similar Requirement but like Jan 15 to Feb 15 will be considered as one month.

How to get the same.

Regards,XXX

[#5]

Unfortunately I don't have a simple solution. If your month always begins on the 15th try yearname (StartDate, 15, 7) as FiscalYear.

I too have a similar need to split months and what I have done is created an excel workbook with a list of all dates, I link these dates to my orders table.

I then use the Year_Period column as a reference in the reports

OrderH:
order_no,
order_date,
order_date as JJ_Date,
customer

.....
From Table orders;

SJ_Date:
NOCONCATENATE LOAD
JJ_Date,
[Year_Period] as SJ_Year_Period
FROM [\\Peiintdub1\qlikviewreports\Qlikview_Excel\Qlikview\SJ Dates.xls] (biff, embedded labels, table is [Sheet2$]);