Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Financial Calendar

Hi all,

Can any one please send me the sample financial calendar.

1 Solution

Accepted Solutions
Not applicable
Author

see attachment

from this code you get all the fields related to date

hope this helps you.

Regards

View solution in original post

7 Replies
Not applicable
Author

for making financial calender,

in scrip write this code.

load *,

Yearname(datefield,0,2) as financialyear

from table;

Not applicable
Author

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
Author

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
Author

Can you paste one sample qvw.

Not applicable
Author

see attachement.

Not applicable
Author

see attachment

from this code you get all the fields related to date

hope this helps you.

Regards

Not applicable
Author

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