topic Re: Reporting Calendar in QlikView

Reporting Calendar

chris_johnson — Mon, 21 Aug 2017 09:19:36 GMT

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?

Re: Reporting Calendar

Anil_Babu_Samineni — Mon, 21 Aug 2017 10:05:43 GMT

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.

Re: Reporting Calendar

its_anandrjs — Mon, 21 Aug 2017 10:16:32 GMT

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

Re: Reporting Calendar

chris_johnson — Mon, 21 Aug 2017 11:01:52 GMT

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

Re: Reporting Calendar

chris_johnson — Mon, 21 Aug 2017 11:05:46 GMT

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.