Qlik Sense Variance in Set Analysis

[bann-p-1]

Hi, 

I have been using Qlik for about six months and I want to do a variance on two columns in a Qlik Sense pivot table.

I have created a pivot table, put my data in and now I want to do a variance on two averages. I get stuck when trying to do the variances, below is a screen grab of what I'm looking to and the expression I have tried to use so far.

Expression: Sum({<Year={'=MAX(Year)-1'}>}( ClientDamagePaymentAmount)).

Everything I try doesn't give me the result I'm looking for ?

Thanks, any help appreciated

[rubenmarin · Accepted solution]

Hi, maybe using Before():

(ExpressionForAvg)-Before(ExpressionForAvg)

Same expression on both sides, no need of set analysis to get last year

[bann-p-1]

Thank you very much that worked.