Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor

Month name to Financial year in qliksense

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

3 Replies
Highlighted
Partner
Partner

Re: Month name to Financial year in qliksense

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

Highlighted
Contributor

Re: Month name to Financial year in qliksense

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

Highlighted
Partner
Partner

Re: Month name to Financial year in qliksense

share your script please