Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

philipp_meissne
New Contributor

Fiscal Year to Month: Display months floating over Years

Dear Community,

I have a question on displaying Fiscal Years and Months. My aim is to be able to display Volumes floating over Fiscal Years (Fiscal Year starts in Oct). So out of the data I want to be able to select e.g. Aug FY 2017 to Dec FY 2018.

Thank you very much in advance!

 

Fiscal YearMonth
2017Oct
2017Nov
2017Dec
2017Jan
2017Feb
2017Mar
2017Apr
2017May
2017Jun
2017Jul
2017Aug
2017Sep
2018Oct
2018Nov
2018Dec
1 Reply
philipp_meissne
New Contributor

Re: Fiscal Year to Month: Display months floating over Years

Solved it myself

Added a mapping table which dims Months as Periods.

Then used ="Fiscal Year (FY)"&'/'&Period in the Data Dimension Field.