topic Re: First week of the Financial Year in QlikView

First week of the Financial Year

Fri, 11 Apr 2014 12:40:46 GMT

Hi All,

I am trying to split Year, Quarter, Month, Week and Day from my Date column

I am incorporating Indian Financial Calender 2014-15 i.e First Month is April 14 and last Month is March 15

I need your assistance to get the first week of the Financial Year i.e. the first week of Apri l14 should be the first week of the year, I am using Weekname function but am unable to get the result

Attached is the Data and QVW.

Thanks in advance.

Re: First week of the Financial Year

whiteline — Fri, 11 Apr 2014 14:37:33 GMT

Hi.

According to QV help:

"If you want to work with weeks not starting midnight between Sunday and Monday,

indicate an offset in days in weekoffset."

So, you have to calculate the offset in days:

WeekName([Appointment_Date],0, DayNumberOfYear(makedate(year([Appointment_Date]), 4, 1)))

Re: First week of the Financial Year

Gysbert_Wassenaar — Fri, 11 Apr 2014 14:45:53 GMT

See attached qvw for a calendar creation script that also generates the week numbers.

Re: First week of the Financial Year

antoniotiman — Fri, 11 Apr 2014 14:54:36 GMT

It depends on the query on your DB.

For example in MySql :

Week(Data,3) means the first week of the year is 1 and the first day of week is Monday.

The Default as Week(Data) is the first weeh of day 1 and the first day of week Sunday.

Regards,

Antonio

Re: First week of the Financial Year

Sat, 12 Apr 2014 04:11:19 GMT

Hi White Line,

Your code worked, however for the first week of the Year i.e 1st week of April 2014 the days getting highlighted are from 1st Apr 2014 to 07th Apr 2014.

Actually the 1st week of the year 2014, should start from 30th March 2014(Sunday) and end at 05th April 2014 (Saturday)

Re: First week of the Financial Year

whiteline — Sat, 12 Apr 2014 09:47:43 GMT

WeekName([Appointment_Date],0, DayNumberOfYear(makedate(year([Appointment_Date]), 3, 30)))

There is no magic. Read the QV help.