Discussion Board for collaboration on QlikView Scripting.
Here my fiscal calener is started from Sep-Aug and i don't have months i have periods that each period contains 28 days only.
how can i make Quarter,Period,Week without hard code i want to make it as dynamic calender because i can't work on each year for manually changing the calender.
Please find attached file for Fiscal year and for making periods.
Thanks in Advance plz help
Suggest me some way?
I depends on how it is defined... If the fiscal year always starts on the first Monday of September, and each Period is 28 days long, the following can be used as script:
Load *, 1 + Div(Date - FirstDayOfYear,28) as Period;Load *, WeekStart(YearStart(WeekStart(Date),0,9)-1,1,0) as FirstDayOfYear; //First Monday of yearLoad Date(MakeDate(2012,8,31)+RecNo()) as Date Autogenerate 3000;
...and if the year start instead is on the Monday closest to Sept 1st, the following can be used:
Load *, 1 + Div(Date - FirstDayOfYear,28) as Period;Load *, WeekStart(4+YearStart(WeekStart(Date),0,9)-1) as FirstDayOfYear; //Monday closest to 9/1
Thanks for reply it's helpful to me.