Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
danielle_v
Contributor

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

Re: Year Starting in September

hi

try this

YearName(datefield,0,7) as new_year

then year start with september as first month

MVP
MVP

Re: Year Starting in September

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
Valued Contributor

Re: Year Starting in September

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

srikanthsri1
Valued Contributor

Re: Year Starting in September

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
Contributor

Re: Year Starting in September

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
Valued Contributor

Re: Year Starting in September

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

Community Browser