Solved: Showing 12 months in chart of fiscal year - Qlik Community

Anonymous · ‎2014-08-20

(Please see attached file)

I've got a data set with fiscal year in it. The new year starts 1 of April.

If a customer selects a fiscal year and month, I want to see the last 13 months in the chart.

Expression = Sum([Net Sales])

Dimension = MonthYear

What is the correct set analysis for this example?

Report Inappropriate Content · ‎2014-08-20

Attached is an example of how to approach this. I did it with Variable event trigger and an input box. So based on the values entered by the user, it will automatically select past 12 months in the application, so the chart will also be filtered for 12 months of data.

One thing to note, this will affect the entire application(ie the whole app will be filtered for 12 months of data).

Thanks

View solution in original post

Report Inappropriate Content · ‎2014-08-20

Attached is an example of how to approach this. I did it with Variable event trigger and an input box. So based on the values entered by the user, it will automatically select past 12 months in the application, so the chart will also be filtered for 12 months of data.

One thing to note, this will affect the entire application(ie the whole app will be filtered for 12 months of data).

Thanks