Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, maybe using Before():
(ExpressionForAvg)-Before(ExpressionForAvg)
Same expression on both sides, no need of set analysis to get last year
Hi, maybe using Before():
(ExpressionForAvg)-Before(ExpressionForAvg)
Same expression on both sides, no need of set analysis to get last year
Thank you very much that worked.