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: 
sunil2288
Creator III
Creator III

How to create Financial year from Normal date period

HI all

I have a query that how i can create Financial year that is Apr to Mar from normal date period.

Comments appreciated

Thanks and Regards

Sunil

Labels (1)
1 Solution

Accepted Solutions
Not applicable

Dear Sunil,

You canget financial year by using function called 'Yearname"

ex: yearname(Date_Field,0,4)

It will treat Apr as the first month in finanacial Year.Check and let me know.

Thanks & Regards

Jai

View solution in original post

2 Replies
Not applicable

Dear Sunil,

You canget financial year by using function called 'Yearname"

ex: yearname(Date_Field,0,4)

It will treat Apr as the first month in finanacial Year.Check and let me know.

Thanks & Regards

Jai

sunil2288
Creator III
Creator III
Author

Hi Ij,

Thanks Ij... It Works...

Regards

Sunil