Discussion Board for collaboration on QlikView Scripting.
I have completed application with Calendar Year. Now I want to convert Calendar Year to Financial Year in the same application.
Any suggestions would be greatly appreciated.
Thanks in Advance.
Please refer below document
Fiscal and Standard Calendar generation
are you using a master calendar script (https://community.qlik.com/thread/48693)? You may add some new fields to master calendar with the Financial Year info. This is an example:
Rename Table MasterCalendar to tmp;
if(Quarter = 'Q1', Year - 1, Year) as [Financial Year],
if(Quarter = 'Q1', 'Q4','Q' & Text(Right(Quarter,1) - 1)) as [Financial Quarter]
Drop Table tmp;