Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Fiscal year help

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!

Tags (1)
1 Solution

Accepted Solutions
Employee
Employee

Re: Fiscal year help

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.

2 Replies
mwoolf
Honored Contributor II

Re: Fiscal year help

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.

Employee
Employee

Re: Fiscal year help

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.

Community Browser