Financial Calendar

[#1]

Hi all,

Can any one please send me the sample financial calendar.

[#2]

for making financial calender,

in scrip write this code.

load *,

Yearname(datefield,0,2) as financialyear

from table;

[#3]

Hi Vishwaranjan,

   Thanks for your reply but i need entire script for create month and quarter also i know how to create year.

[#4]

you can also try this code

[Financial Calendar]:

LOAD *

,dual('Q' & if(month(Date)<4,4,floor(month(Date)/3)) & ' ' & FinancialYear,quarterstart(Date)) as FinancialQuarter

;

LOAD *

,date(yearstart(Date,0,4),'YYYY') as FinancialYear

;

LOAD date(date#(20010331,'YYYYMMDD')+recno()) as Date

AUTOGENERATE today()-date#(20010331,'YYYYMMDD')

;

see link this helps you

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year

[#5]

Can you paste one sample qvw.

[#6]

see attachement.

[#7 · Accepted solution]

see attachment

from this code you get all the fields related to date

hope this helps you.

Regards

[#8]

Hi VISHWARANJAN

            I done same thing for financial calender but the out put is 2001-2002 right ?

            son ow  i want output like 2110-02 instead of 2001-2002   while  creating the financial year

            can u suggest me how we can do

thanks