How can I create Yearly Char

mokitsu61 — Mon, 14 May 2018 06:37:43 GMT

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.

topic How can I create Yearly Char in QlikView