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: 
danielle_v
Creator
Creator

Year Starting in September

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

6 Replies
Not applicable

hi

try this

YearName(datefield,0,7) as new_year

then year start with september as first month

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jolivares
Specialist
Specialist

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

Anonymous
Not applicable

hi

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

danielle_v
Creator
Creator
Author

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

jolivares
Specialist
Specialist

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