topic Re: add calcuated column in pivot table in QlikView

add calcuated column in pivot table

adamjwchen — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a pivot table as below. Dimension(Year) is manipulated, I would like to get the variance column, can someone get me some hints?

devarasu07 — Tue, 05 Dec 2017 09:03:42 GMT

Hi,

Try like this,

Variance:

sum(Amount) - before(sum(Amount))

or other way,

Create Measure like below,

=Max(Year) // current year

sum( {$<Year={"$(=max(Year))"}>} Amount)

=max(Year)-1 // previous year

sum( {$<Year={"$(=max(Year)-1)"}>} Amount)

Variance:

Column(1)-Column(2)

tresB — Tue, 05 Dec 2017 09:26:46 GMT

May be like this?