topic Re: Fiscal year calendar set analysis in QlikView

Fiscal year calendar set analysis

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a variable vFM which denotes the month number in which the financial (Fiscal) year starts.

I have the following Calendar Year flag expressions:

MonthName(today()) as This_Month,

MonthName(AddMonths(today(),-1)) as Prev_Month

How can i change these to give the corresponding financial (Fiscal) year equivalents, i.e. FiscalThis_Month and FiscalPrev_Month?

Regards.

Chris

Re: Fiscal year calendar set analysis

Gysbert_Wassenaar — Thu, 05 May 2016 07:38:06 GMT

The MonthName function returns the name of a month. Using a fiscal calendar does not change the names of months. April will still be April, regardless of it being the first, fourth or tenth month of your fiscal calendar.

Re: Fiscal year calendar set analysis

saumyashah90 — Thu, 05 May 2016 07:43:54 GMT

dont get your question

Re: Fiscal year calendar set analysis

jonathandienst — Thu, 05 May 2016 08:10:12 GMT

These may help:

Fiscal Year

Relative Calendar Fields

Fiscal and Standard Calendar generation

Re: Fiscal year calendar set analysis

Anonymous — Thu, 05 May 2016 08:28:28 GMT

Thank you

Re: Fiscal year calendar set analysis

Anonymous — Thu, 05 May 2016 08:28:45 GMT

Thanks for the links