Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
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.
Regards,
P.Divya
Hi Divya,
Please refer below document
Fiscal and Standard Calendar generation
Hi,
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;
MasterCalendar:
Load
*,
if(Quarter = 'Q1', Year - 1, Year) as [Financial Year],
if(Quarter = 'Q1', 'Q4','Q' & Text(Right(Quarter,1) - 1)) as [Financial Quarter]
Resident tmp;
Drop Table tmp;