Calculate CY-LM, CY-YTM & CY-MTD, but month cycle not based on calendar month

[bharat19s]

Hi

I want to calculate Last Month (CY-LM) Sales and Year to Last Month (CY -YTM) Sales and Month to date (CY-MTD) sales.

But the month cycle is 27^th of the previous month to 26^th of the running month. Its not as per the calendar month, So i can't use MonthStart and MonthEnd function of QlikView.

Can i create my own function like MonthStart and MonthEnd which will consider this cycle?

I tried following ways but it will not work,if i run report between 27th to 31st of the month properly.

CY LM :-

Start: =Date(monthstart(AddMonths(Today(),-2))+ day(27),'YYYY-MM-DD')

End: =Date(monthstart(AddMonths(Today(),-1))+ day(26),'YYYY-MM-DD')

CY YTM :-

Start: =Date(YearStart(Today(),0,4),'YYYY-MM-DD')

End: =Date(monthstart(AddMonths(Today(),-1))+ day(26),'YYYY-MM-DD')

CY MTD :-

Start: =Date(monthstart(AddMonths(Today(),-1))+ day(27),'YYYY-MM-DD')

End: =Date(Today(),'YYYY-MM-DD');

[sunny_talwar · Accepted solution]

May be look here:

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