Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Fiscal year calendar set analysis

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

5 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
saumyashah90
Specialist
Specialist

dont get your question

jonathandienst
Partner - Champion III
Partner - Champion III

These may help:

Fiscal Year

Relative Calendar Fields

Fiscal and Standard Calendar generation

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

Thank you

Anonymous
Not applicable
Author

Thanks for the links