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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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