topic Re: Year Starting in September in QlikView

Year Starting in September

danielle_v — Fri, 05 Apr 2013 14:00:47 GMT

Hi All,

I am working on a report in which the year needs to start in September.

So September needs to be the first month in the year, and week 1 needs to be the first week in September (in 2012 for example, week 1 started on 03/09/12 ).

Any year to date calculations would need to take this into account too. For example, if I was putting together a chart to show orders placed YTD, this would need to run on a September - August year.

I'm hoping this may be an easy question to fix, but I currently have no idea where to start so any help would be greatly appreciated!

Thanks,

Danielle

Re: Year Starting in September

Fri, 05 Apr 2013 14:05:04 GMT

try this

YearName(datefield,0,7) as new_year

then year start with september as first month

Re: Year Starting in September

jonathandienst — Fri, 05 Apr 2013 14:07:28 GMT

Danielle

I suggest that in your script you create a month sequence number field, something like

LOAD ....

Year(TranDate) * 12 + Month(TranDate) As MonthSequence

...

And sort by the month sequence number

Hope that helps

Jonathan

Re: Year Starting in September

jolivares — Fri, 05 Apr 2013 14:44:16 GMT

I already use october, try to use to diferent dates, the calendar one and fiscal, so when you load your data transform it.

Load...Inv_Date, Date(AddMonths(Inv_Date,4)) as Fiscal_Inv_Date...

Re: Year Starting in September

Anonymous — Fri, 05 Apr 2013 15:25:18 GMT

just creat a new fiscal date like this

addmonths(date,4) as fiscal date

which will show as jan as your 1st month (but it is fiscal)

do all transforamtion to this fiscal date

Hope this helps

Thanks

Re: Year Starting in September

danielle_v — Fri, 05 Apr 2013 16:00:48 GMT

Hi All,

Many thanks for your help so far!

I have tried out the YearName suggestion, and although this does successfully align the months to a September-starting year, it doesn't align the week numbers, so week 1 is still from the end of December / beginning of January.

Do you know how I would align the week numbers too?

Thanks again,

Danielle

Re: Year Starting in September

jolivares — Fri, 05 Apr 2013 19:45:43 GMT

You have to transforms all dates you are using...