Fiscal year help

[#1]

My company just got qlikview in the past month so I am very new.

My data load from SQL uses calendar year but I want to represent fiscal year in Qlikview.

How do I do that in the script editor?

Thanks!

[m_woolf]

If you search the forum for fiscal year, you will find:

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

and many other posts.

[Agis-Kalogiannis · Accepted solution]

The inyeartodate() function in the MasterCalendar, which creates the flags, can be modifies accordingly if you add a forth parameter.

Check QV help for more info.