
Partner - Creator
2019-03-29
08:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
365 Views
1 Reply

MVP
2019-03-30
02:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this formula
Num(month(month name(DateField,3))) as [Fiscal month]
Num(month(month name(DateField,3))) as [Fiscal month]
Vegar
Qlik Community MVP
Qlik Community MVP
345 Views
