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

How to make fiscal calender as Dynamic?

Hi All,

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

Thanks,

Ashok.

4 Replies
Not applicable
Author

Suggest me some way?

hic
Former Employee
Former Employee

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 year
Load
Date(MakeDate(2012,8,31)+RecNo()) as Date
Autogenerate 3000;

HIC

hic
Former Employee
Former Employee

...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

HIC

Not applicable
Author

Hi Henric,

Thanks for reply it's helpful to me.

Thanks,

Ashok.