calendar year to fiscal year

[Anonymous]

is there a way in the load settings to change calendar year to fiscal year?  I want the 1st month to be Oct and the last month to be sept.

Thanks,

Maria

[Gysbert_Wassenaar]

See this blog post: Fiscal Year

Works for Qlik Sense too.

[shraddha_g]

In main section,

there are all default variables are set.

Change SET FirstMonthOfYear=1; to SET FirstMonthOfYear=10;

and then try.

[Anonymous]

ok.  so my work around is

If(Month(MonthYear) >= 10, Month(MonthYear)-9, Month(MonthYear)+3) as FYYearMonthNum,

If(Month(MonthYear) >= 10, Text(MonthName(addYears(MonthYear, 1))), Text(MonthYear)) as FYDisplayYearMonth,

If(Month(MonthYear) >= 10, YearName(addyears(FYYear, 1)), FYYear) as FYDisplayYear

MonthYear is the actual calendar year value.  so, I want it to do this..

When MonthYear is Oct 2017, create an FY DisplayYear month to be a string representation of Oct 2018.  however, the problem with how I'm doing it above is that it's also changing the MonthYear to Oct 2018 as well.  how can I reference MonthYear in a function without changing its value in the process?

[#5]

I tried changing the FirstMonthOfYear to 9 (which is what I need) and it has no effect. (Qlik Sense 3.2)

[#6]

The fact that you propose a workaround makes me think that "FirstMonthOfYear" does not really work. (which is my experience) [Sense 3.2]

[Anonymous]

greetings.

that will not work.  I had to do a much more extensive workaround in the data load.  I don't know if what I did was the most efficient method, but it worked..

are you still trying to figure it out?

[arvind_patil]

Hi Maria,

You will get Basic Idea from Below link:

just replace all 4  to 9

Different fiscal year from calender year

Thanks,

Arvind Patil

[UTKARSH007]

Madam/ Sir,

Use the line in the script if in case of if you are using Date content as given below:-

YearName(Date,0,10) as FiscalYear,

Here 10 is the month no. and 0 is period no. (by default it remains 0).

save and reload. This may help you out.