topic Re: create fiscal week in QlikView

create fiscal week

arulsettu — Wed, 10 Sep 2014 05:54:01 GMT

i am having date field like this 20140608. and having fiscal year field values like 2014 and fiscal month values like 12. now i need fiscal week. how to create it any help?

Re: create fiscal week

ecolomer — Wed, 10 Sep 2014 06:11:24 GMT

You can see this:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year

Re: create fiscal week

arulsettu — Wed, 10 Sep 2014 06:14:30 GMT

i already saw that. it dont have fiscal week

Re: create fiscal week

vardhancse — Wed, 10 Sep 2014 06:16:43 GMT

Fiscal week/year we need to define in our calendar.

because it varies from one organization to another organization.

Eg: for calendar week and fiscal week, we can make

'WK'&'-'&Div(TempDate-YearStart(TempDate)+WeekDay(YearStart(TempDate)+1)+7,7)

as Calendar_Week,

'FWK'&'-'&Div((TempDate+'61')-YearStart((TempDate+'61'))+WeekDay(YearStart((TempDate+'61'))+3)+7,7)

as Fiscal_Week,

Re: create fiscal week

Wed, 10 Sep 2014 06:23:36 GMT

Maybe this can help you:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/21/week-start

http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/27/week-numbers

Regards

Re: create fiscal week

jagan — Wed, 10 Sep 2014 06:51:08 GMT

Hi,

Try like this

DayNumberOfYear(date[,firstmonth])

--firstmonth is the starting month of the year.

Ex:

LOAD

Ceil(DayNumberOfYear(DateFieldName, 4]))/7 AS FiscalWeek -- Assuming April is the starting month of Fiscal year

FROM Datasource;

Regards,

Jagan.

Re: create fiscal week

arulsettu — Wed, 10 Sep 2014 07:14:47 GMT

i am getting following result

thanks

Re: create fiscal week

jagan — Wed, 10 Sep 2014 07:53:18 GMT

Hi,

Try like this

Ceil(DayNumberOfYear(DateFieldName, 4)/7)

Regards,

jagan.

Re: create fiscal week

arulsettu — Wed, 10 Sep 2014 07:56:32 GMT

i changed already. one doubt how its different from ordinary calendar week can you explain?

Thanks

Re: create fiscal week

jagan — Wed, 10 Sep 2014 08:01:35 GMT

Hi,

Normal calendar starts from Jan 1, for normal calendar DayNumberOfYear(DateFieldName) will give 1 for Jan 1, 2 for Jan 2, 3 for Jan 3 and so on.

For Fiscal (the second parameter FirstMonth) specifies the start date of a calendar, for example if you give then the start date of the year is 1 Apr. So DayNumberOfYear(DateFieldName) will give 1 for Apr 1, 2 for Apr 2, 3 for Apr 3 and so on.

We are dividing the result by 7 for DayNumberOfYear() to get the week number.

Hope this helps you.

Regards,

Jagan.

Re: create fiscal week

arulsettu — Wed, 10 Sep 2014 08:03:44 GMT

thanks