Discussion Board for collaboration on QlikView Scripting.
Can any one please send me the sample financial calendar.
Go to Solution.
from this code you get all the fields related to date
hope this helps you.
for making financial calender,
in scrip write this code.
Yearname(datefield,0,2) as financialyear
Thanks for your reply but i need entire script for create month and quarter also i know how to create year.
you can also try this code
,dual('Q' & if(month(Date)<4,4,floor(month(Date)/3)) & ' ' & FinancialYear,quarterstart(Date)) as FinancialQuarter
,date(yearstart(Date,0,4),'YYYY') as FinancialYear
LOAD date(date#(20010331,'YYYYMMDD')+recno()) as Date
see link this helps you
Can you paste one sample qvw.
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