topic Fiscal year in QlikView

Fiscal year

Fri, 30 May 2014 11:34:55 GMT

how to create fiscal year from given date

Fri, 30 May 2014 11:36:13 GMT

Try this

PrashantSangle — Fri, 30 May 2014 11:39:00 GMT

Hi,

Use YearName(DateField,0,4)

Regards,

arulsettu — Fri, 30 May 2014 11:43:22 GMT

LOAD *,

Day(date) as day,

Month(date) as month,

Year(date) as year,

yearname(date,0,4)as FinancialYear;

sasikanth — Fri, 30 May 2014 11:43:48 GMT

Try some thing like this

=Year(date('date field','DD/MM/YYYY))

Anonymous — Fri, 30 May 2014 12:41:20 GMT

Try this:

[Requesterdate] means your date field in the Data ..

right(year(addmonths([Requester Date],-3)),2) & '-' & right(year(addmonths([Requester Date],-3))+1,2)