Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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