topic Re: Fiscal Month Day Number in QlikView

Fiscal Month Day Number

Fri, 29 Jan 2016 06:07:52 GMT

Hi All

I have a fiscal month field. Fiscal month starts on the 26th to the 25th of the following month. I would like to create a field to num() my fiscal month days. Eg 26th Jan would be day 01 and 25th Feb will be day 31. How can I do this?

Re: Fiscal Month Day Number

jagan — Fri, 29 Jan 2016 07:00:07 GMT

Hi,

Try like this

MasterCalendar:

LOAD Date,

Date(monthstart(Date-25,1),'MMM-YYYY') as Month,

Day(Date(Date-25)) AS Day ;

LOAD

Date(makedate(2015)+recno()-1) as Date

AutoGenerate 732;

Hope this helps you.

Regards,

Jagan.

Re: Fiscal Month Day Number

Fri, 29 Jan 2016 07:14:18 GMT

Thanks Jagan...Always a great help!

Re: Fiscal Month Day Number

jagan — Fri, 29 Jan 2016 07:21:00 GMT

Hi,

Check this link for details

Fiscal Calendar with Non-Standard Days (Not 1-31)

Regards,

Jagan.