Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mokitsu61
Creator
Creator

How can I create Yearly Char

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.

0 Replies