variance in pivot table

[stoic_presi]

Hi ,

I am new to Qlik Sense. I have created a pivot table with current year and last year as columns and rows are calculated measures. I need a 3rd column which is the difference/variance  of  curr. year and last year. I have currently used a separate table to calculate the variance but i want it in the same table.

thanks.

[Channa]

Dimension Row : Company

Column : ValueList('CurrentYear','PreviousYear','Varience')

Measure :

pick(match(ValueList('CurrentYear','PreviousYear','Varience'),'CurrentYear','PreviousYear','Varience'),
sum({<Year={'CurrentYear'}>}value),
sum({<Year={'PreviousYear'}>}value),
(sum({<Year={'CurrentYear'}>}value)-sum({<Year={'PreviousYear'}>}value))
)

--you can do this with ValueList--try to read about it