# New to Qlik Sense

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

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for
Did you mean:
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?

Labels (7)

• ### Year-Over-Year

3 Replies
Specialist II

Use 2 dimensions,

Year and Month

Contributor III
Author

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

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.

Tags
Community Browser