Reporting Calendar

[chris_johnson]

Hi all,

I have a conundrum which I'm trying to solve.

I need to have a reporting calendar that starts around the 1st August each year. Some extra rules are that week 1 needs to start on a Monday, but if the 30th or 31st July are a Monday then the reporting year will start on that day.

Anyone got anything that does this?

[Anil_Babu_Samineni]

Looks like you need some dimensions over here. Does those you are attempting something like below

If(DateField >= Match(WeekDay(DateField), 'Mon'), DateField)

Here, If rules are crossed more than one you could use OR operator to split into multi conditions from each rule.

[its_anandrjs]

Yo are asking about some thing Fiscal Year calendar.

Go with some of this threads

https://community.qlik.com/docs/DOC-18299

Fiscal Calendar Flag

[chris_johnson · Accepted solution]

Thanks for the replies, I ended up using something along the lines of this post by HIC:

https://community.qlik.com/blogs/qlikviewdesignblog/2014/01/27/week-numbers#start=25

I modified the reference date to start the reporting year when I wanted and it seems to work.

I'll have to keep an eye on things with regards to leap years (as mentioned in the article) to see if this knock anything out.

Thanks

[chris_johnson]

Just to detail as well, it wasn't exactly the same as the Fiscal Calendar as this "Reporting Calendar" needs to have the year starting on a Monday, as opposed to the 1st of the Month, because it works on complete weeks, not months.