MakeDate Fiscal Dates

[abhaysingh]

Hi all,

I have Data From Apr to Mar as per fiscal year... I want to define Dates as per Fiscal Month

like below

Apr - 01-01-15

May-01-02-15

jun- 01-03-15

july- 01-04-15

aug- 01-05-15

sep-01-06-15

oct-01-07-15

nov-01-08-15

Dec- 01-09-15

jan-01-10-16

Feb-01-11-16

Mar-01-12-16

Right now I m doing like this makedate(2015,MonthNumber,01)

MonthNumber = 01,02,03,04,05,06,07,08,09,10,11,12

and 01 it is taking Jan instead of Apr.

How I can get above result In term  of dates..

Thanks

[sunny_talwar]

See if this one helps:

MakeDate(If(MonthNumber >= 4, 2015, 2016), If(MonthNumber >= 4, MonthNumber - 3, MonthNumber + 9), 1)

[somenathroy]

Hi,

You may try the YearStart() function as below code:

SET vStartDate = '01-Jan-2015';

SET vEndDate = '01-Dec-2015';

DateCal:

LOAD *, YearStart(Date,1,4+RecNo()-1) as FDate;

LOAD

  AddMonths(Date(Date#('$(vStartDate)','DD-MMM-YYYY'),'DD/MM/YYYY'), RecNo()-1) as Date

AutoGenerate 12;

Regards,

Som

[PrashantSangle]

Hi,

Have you try my suggestion??

Regards

[qlikviewwizard]

Hi Abhay,

Please change the default month names as shown below. Hope this will help you. Thank you.

SET MonthNames='Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec;Jan;Feb;Mar';