Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Showing results for 
Search instead for 
Did you mean: 
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.


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

3 Replies
Specialist II
Specialist II

Use 2 dimensions,

Year and Month 

Contributor III
Contributor III

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

Partner - Contributor III
Partner - Contributor III

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.