Month name to Financial year in qliksense

[marishnagendran]

Dear All,

I have Month Name Column as on field (i.e) Sep 18,Aug 18 Etc, I Want to find the financial year for this column

Financial Year is Apr to Mar

[martinpohl]

if your month name column also has a date information you can

year(addmonths(date,9)) & num(month(addmonths(date,9)),'00') as FiscalPeriod

1.4.2018 + 9 months = 1.1.2019 = 201901

1.9.2018 + 9 months = 1.6.2019 = 201906

If not, separate month and year information from your field and use makedate()

Regards

[marishnagendran]

I'm using Makedate Function only but it is not working properly if you have done this kindly share your script

[martinpohl]

share your script please