YOY Variance

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have this table:

I want to calculate the difference between each year (i.e. 2016 vs 2015, 2015 vs 2014)

Keep in mind that the year column (employers, work locations, contracts, members) are all calculated expression and the year is a dimension.

Can anybody help?

Re: YOY Variance

migueldelval — Thu, 23 Jun 2016 08:43:10 GMT

Hi Joenunez,

If I have understood well, you need to calculate the difference between years. There aren´t problems with the calculated expression. you only need to add one expression with set analysis for each.

For example If you are Sum(Employers) -->

=(Sum({<Year={"2016"}>}Employers))-(Sum({<Year={"2015"}>}Employers))

Your result are going to be the difference between years.

Is this information correct for your problem?

Regards

Miguel del Valle

topic YOY Variance in QlikView

YOY Variance

Re: YOY Variance