Discussion board where members can get started with Qlik Sense.
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.
|Country||Region||Fiscal Year||Fiscal Qtr||Month||$|
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.
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?