Fiscal year

[#1]

how to create fiscal year from given date

[#2]

Try this

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

[PrashantSangle]

Hi,

Use YearName(DateField,0,4)

Regards,

[arulsettu]

LOAD *,

Day(date) as day,

Month(date) as month,

Year(date) as year,

yearname(date,0,4)as FinancialYear;

[sasikanth]

hi

Try some thing like this

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

[Anonymous]

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)