Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
john_henry
Not applicable

How to calculate Year over Year growth measures

I have a dataset (see simple example below) that I need to calculate YoY metrics (calculation: current year divided by last year minus 1) by any combination of country, region, Year, qtr, and month.  For example, I'd like to have filters for country, region, year, qtr, and month and then create a KPI chart that showed the YoY % growth.  For example, if I chose US->Central->2016->Q1->Nov from filters, I would get a YoY % decline of -50% ($5/$10-1).  If I chose LAC->Brazil->2016->Q1 from filters, I would get a YoY % decline of -33% ($30/$45-1).  Keep in mind that I will have many years in this dataset, so it needs to be dynamic.

CountryRegionFiscal YearFiscal QtrMonth$
USCentral2015Q1Nov10
Dec15
Jan20
2016Q1Nov5
Dec10
Jan15
LACBrazil2015Q1Nov10
Dec15
Jan20
2016Q1Nov5
Dec10
Jan15
9 Replies
handry_orozco
Not applicable

Re: How to calculate Year over Year growth measures

Friend

Try this

@ !

Khan_Mohammed
Not applicable

Re: How to calculate Year over Year growth measures

Year-over-Year Comparisons

YoY Growth

Check more on community related to YOY.

Or if you can, upload a sample file/data?

Thanks.

john_henry
Not applicable

Re: How to calculate Year over Year growth measures

this appears to be in QlikView, however, I am working in QlikSense.  Can you send in QlikSense?

john_henry
Not applicable

Re: How to calculate Year over Year growth measures

attached is sample data

Khan_Mohammed
Not applicable

Re: How to calculate Year over Year growth measures

It's for both.

I believe in above links they are giving an example script, which will be same in Qlik Sense and Qlikview.

The front end will be different but expressions/script is same.

Khan_Mohammed
Not applicable

Re: How to calculate Year over Year growth measures

You can check the attached qvf.

I'm not sure about the expression but the data model has been made for you with the help of Master Calendar.

If you find my expression or the result as in correct, you can further edit it or maybe someone else can?

Thanks.

john_henry
Not applicable

Re: How to calculate Year over Year growth measures

Thanks Shahbaz...unfortunately the expression is not yielding the right number.

Khan_Mohammed
Not applicable

Re: How to calculate Year over Year growth measures

I guessed it, the expression might not be what you need.

What result are you expecting or do you have an expression already?

john_henry
Not applicable

Re: How to calculate Year over Year growth measures

see my original post for calculation and examples...thx!