Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Growth rate year over year in same graph

Hi All,

I am looking to have a line chart to show growth rate fiscal year over fiscal year in the same graph(attached). So the idea is whenever  a user selected for example the fiscal month = September. The year over year should change for only September months.

There are three filters in the dashboard -

Fiscal Year - FY15,FY16,FY17, FY18 etc..

Fiscal Year Quarter - 2015/Q1,2015/Q2,2015/Q3,2015/Q4,2016/Q1 etc..

Fiscal Month - February, March, April etc....

In the attached chart I have the below set analysis in the measures.

Sum({<METRIC_NAME = {'approve'},CLASSIFY = {'CUSTOMER','PARTNER'}>}METRIC_VALUE). 

How do I create a second measure to show growth rate fiscal year over fiscal year?

 
 
 
3 Replies
Highlighted
Specialist II
Specialist II

Use 2 dimensions,

Year and Month 

Highlighted
Contributor III
Contributor III

Can you help me with the set analysis formula. to show that?

Highlighted
Partner
Partner

Hi , 

1.If you need a user to select the Sep month and the chart should show only the year wise split of value.

Sol: Drill down function : month and Year as dimension.

Note: You can find drill down dimension in the Masters section.

2. Showing month wise data for all the years is something very illogical, but if your requirement is to have that, do the following.

Sol :  *Have a filter pane which has month in it.

           *Then have a chart by having fiscal year as dimension in it. 

           *Set the calculation condition as Getselectedfieldcount(Month) >1 on the add-on tab on the right.