how to create current year fiscal calendar in qlikview

[kulasekhar]

Hi All,

how to create current year fiscal calendar in qlikview

I have 3 years data like:2012-2013

                                   2013-2014

                                   2014-2015

And fiscal start month is Nov.

Place help me.

[kulasekhar]

I want to display Current year data (2014-2015)

[ganeshreddy]

Hi sekhar,

for which country fiscal calender ?

anyway take a look at this..

The Master Calendar

Cheers,

Ganesh

[#4]

Quarter Function

Refer above discussion.

If your First Qtr starts with November you can use :

'Q' & Ceil(Month(AddMonths(Date,-10))/3)

Ex:

Load *,

'Q' & Ceil(Month(AddMonths(Date_Col,-10))/3)   as QTR

;

SQL

Select DATA,

           Date_Col

from Table;