Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Financial Calendar

Hi all,

Can any one please send me the sample financial calendar.

1 Solution

Accepted Solutions
Not applicable

Re: Financial Calendar

see attachment

from this code you get all the fields related to date

hope this helps you.

Regards

7 Replies
Not applicable

Re: Financial Calendar

for making financial calender,

in scrip write this code.

load *,

Yearname(datefield,0,2) as financialyear

from table;

Not applicable

Re: Financial Calendar

Hi Vishwaranjan,

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

Not applicable

Re: Financial Calendar

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

Not applicable

Re: Financial Calendar

Can you paste one sample qvw.

Not applicable

Re: Financial Calendar

see attachement.

Not applicable

Re: Financial Calendar

see attachment

from this code you get all the fields related to date

hope this helps you.

Regards

Not applicable

Re: Financial Calendar

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

Community Browser