Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
crystles
Partner - Creator III
Partner - Creator III

Trailing 12 months with only FY and FM

I have a data set that only has the FYFM field for the date. It is manually put in by the system, so there is no official "Date" field.

I have a master calendar that I use for creating the TTM (Trailing Twelve Months) and the Current and Prior Fiscal Years.

I cant use that calendar now though because the Date that the calendar uses is trying to convert the Month and Year into fiscal dates, and they are already fiscal.

So my question is, how can I create the TTM and Current/Prior Fiscal year from this field? (Our fiscal year begins in October, ends September)

EXAMPLE (Current date of table, 11/1/16)

Fiscal Year and MonthCurrent FYPrior FYTrailing12 Months
2015-05201720160
2015-09201720160
2015-10201720161
2016-01201720161
2016-05201720161
2016-10201720161
0 Replies