topic Re: need Script For FIscal Calender in QlikView

need Script For FIscal Calender

Fri, 12 Jun 2015 05:18:06 GMT

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 — Fri, 12 Jun 2015 05:34:54 GMT

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 — Fri, 12 Jun 2015 05:36:17 GMT

This may helpful to you

jonathandienst — Fri, 12 Jun 2015 05:39:09 GMT

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

Fri, 12 Jun 2015 05:44:29 GMT

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

Kushal_Chawda — Fri, 12 Jun 2015 05:49:50 GMT

Hi,

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

PrashantSangle — Fri, 12 Jun 2015 05:51:58 GMT

Hi,

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

Regards

Fri, 12 Jun 2015 05:53:43 GMT

thank u

Fri, 12 Jun 2015 05:54:08 GMT

thank u