topic Re: Financial Calendar in QlikView

Financial Calendar

Thu, 13 Jun 2013 04:35:45 GMT

Hi all,

Can any one please send me the sample financial calendar.

Re: Financial Calendar

Thu, 13 Jun 2013 04:43:56 GMT

for making financial calender,

in scrip write this code.

load *,

Yearname(datefield,0,2) as financialyear

from table;

Re: Financial Calendar

Thu, 13 Jun 2013 04:47:28 GMT

Hi Vishwaranjan,

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

Re: Financial Calendar

Thu, 13 Jun 2013 04:50:03 GMT

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

Re: Financial Calendar

Thu, 13 Jun 2013 04:57:24 GMT

Can you paste one sample qvw.

Re: Financial Calendar

Thu, 13 Jun 2013 05:24:41 GMT

see attachement.

Re: Financial Calendar

Thu, 13 Jun 2013 05:46:34 GMT

see attachment

from this code you get all the fields related to date

hope this helps you.

Regards

Re: Financial Calendar

Thu, 17 Jul 2014 11:00:45 GMT

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