topic Re: Week(Date) to Fiscal Week in QlikView

Week(Date) to Fiscal Week

darren_dixon — Tue, 19 Nov 2013 10:05:08 GMT

Hi,

I was wondering if anyone knew how I can change Week(Date) to be the fiscal week number rather than calendar year week number.

Thanks,

Darren

Re: Week(Date) to Fiscal Week

Tue, 19 Nov 2013 10:17:40 GMT

Hi ,

In think fiscal calender is a customize calender but

even though you can add wee(Date) + No of weeks diff b/w Fiscal calender and Actual calendar .

Regards

Yusuf

Re: Week(Date) to Fiscal Week

hic — Tue, 19 Nov 2013 13:25:43 GMT

The Week() function cannot be modified.

But there are other functions that you can use to define your own week number. What kind of fiscal year do you have? And does the week always start on the same weekday?

HIC