Hi,
I'm trying to create Yearly Chart.
Fiscal period: 01-Apr to 31-March
--- Data ---
Date | Flag A | Flag B
01-May-2017 | 1 | 0 // Fiscal year: 2017
01-Dec-2017 | 1 | 0 // Fiscal year:2017
01-Jan-2018 | 1 | 0 // Fiscal year:2017
01-Mar-2018 | 1 | 0 // Fiscal year:2017
01-Apl-2019 | 1 | 0 // Fiscal year:2019
I created a chart and I hope it might shows...
4 1
--------------------
2017 2019
But chart show
2 2 1
--------------------
2017 2018 2019
Creating monthly chart which has fiscal period was OK.
But I have no idea about creating Yearly Chart in fiscal periods.
It means...
X axis of Monthly Chart (2017 in fiscal periods) has items as follow
Apr-2017 May-2017 ... Dec-2017 Jan-2018 Feb-2018 Mar-2018
And I want to show data in Yearly Chart like...
2017(Apr-2017 to May-2018)
But QlikView returns following 2 of X axis items
2017(Apr-2017 to Dec-2017) 2018(Jan-2018 to May-2018)
Thank you.