Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
ivandrago
Creator II
Creator II

Financial Year Calendar

Hi,

Has anyone got a Financial Calendar, I want one based on the financial period starting from April to March.

Thanks

Labels (1)
1 Solution

Accepted Solutions
Not applicable

You could try this:

Date:
load
today()-recno()+1 as Date
autogenerate(today()-'2008-01-01');


DateParts:
load
yearname ( Date, 0, 4 )  as FinancialYear
resident Date;

Drop Table Date

View solution in original post

1 Reply
Not applicable

You could try this:

Date:
load
today()-recno()+1 as Date
autogenerate(today()-'2008-01-01');


DateParts:
load
yearname ( Date, 0, 4 )  as FinancialYear
resident Date;

Drop Table Date