Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Calendar Year to Financial Year

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

2 Replies

Re: Calendar Year to Financial Year

Hi Divya,

Please refer below document

Fiscal and Standard Calendar generation

Not applicable

Re: Calendar Year to Financial Year

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;

Community Browser