Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ajinkyabhonsle
New 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
dwforest
Valued Contributor

Re: Growth rate year over year in same graph

Use 2 dimensions,

Year and Month 

ajinkyabhonsle
New Contributor III

Re: Growth rate year over year in same graph

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

Partner
Partner

Re: Growth rate year over year in same graph

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.