need Script For FIscal Calender

[#1]

hi i have scenario,

I have a below attached data based on that i need to create a FIscal calender the fiscal month start from november to october

[PrashantSangle]

Hi,

Create below field in script;

YearName(DateField,0,11) as Fin_Year,

Year(DateField) as Year,

Month(DateField) as Month,

MonthName(DateField) as MonthYear,

Day(DateField) as Day

regards

[Kushal_Chawda]

This may helpful to you

https://community.qlik.com/docs/DOC-7094

[jonathandienst]

Have you searched this site - there are plenty of examples here to get you going?

[#5]

Hi Dreamer thanks for your reply,but here month field displyed jan to dec.i need month field november-october

[Kushal_Chawda · Accepted solution]

Hi,

In the above link in script SET vFiscalYearStartMonth = 11 in your case

[PrashantSangle]

Hi,

When you select Year from Fin_Year Field it will give desired result.

Regards

[#8]

thank u

[#9]

thank u