topic Re: Set dimension values in a pivot table in QlikView

Set dimension values in a pivot table

Wed, 24 Oct 2012 08:06:43 GMT

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

Re: Set dimension values in a pivot table

Anonymous — Wed, 24 Oct 2012 08:24:54 GMT

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

Re: Set dimension values in a pivot table

Wed, 24 Oct 2012 08:50:54 GMT

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...