Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikSensor
Partner - Creator
Partner - Creator

Number of months for current fiscal year

Hi,

I need the number of months from today on for the current fiscal year, which starts on every 1.10.

E.g. for today I would expect to get 6, for monday (1.4.2019) I would expect 7. Any hints how to do that with a formula?

1 Reply
Vegar
MVP
MVP

Try this formula
Num(month(month name(DateField,3))) as [Fiscal month]