Compare Year To Year value in Pivot Table where co... - Qlik Community

Report Inappropriate Content · ‎2017-02-04

Hi

How can I create pivot table where I'm pointing in 2007 column to value from 2006 year? After using TOTAL in sum expression I don't have access to actual column value (for example 2007). The question is how to write expression? Using some variables?

Kind Regards

Przemyslaw Staniszewski

Anil_Babu_Samineni · ‎2017-02-05

Do you mean when you select 2007 then you want to show 2006 Data?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

vinieme12 · ‎2017-02-05

Using Before () function , look it up in help.

Or provide some sample so people here can help you better

Cheers

V

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

Compare Year To Year value in Pivot Table where columns are years