Set dimension values in a pivot table

[#1]

Hi,

I have a pivot table with three columns corresponding to the years 2012, 2011 and the difference bettween them. Now I also want to load 2010 data but I want to keep only three columns. I'm looking for a smart way to show always the last year loaded (2012 so far) with 2011 or with 2010, so the three columns would be 2010-2012-difference or 2011-2012-diference.

How can I do so.

Thanks

[Anonymous]

Here's a thread that explains how to use Set Analysis to pick the years you want to display dynamically:

http://community.qlik.com/message/196848#196848

[#3]

The thread show me how to fix a year but I need to fix two of three year in the view I tried with an 'or' but maybe I did not find the right syntax...