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.
chris_johnson
Contributor II

Reporting Calendar

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?

Tags (1)
1 Solution

Accepted Solutions
chris_johnson
Contributor II

Re: Reporting Calendar

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

4 Replies

Re: Reporting Calendar

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.

Life is so rich, and we need to respect to the life !!!

Re: Reporting Calendar

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

Re: Reporting Calendar

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

Re: Reporting Calendar

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.

Community Browser