topic Problem with Pivot table in QlikView https://community.qlik.com/t5/QlikView/Problem-with-Pivot-table/m-p/214068#M67664 <HTML><HEAD></HEAD><BODY><P>I'd handle it with an "AsOf" table linking an AsOfYear to both the current year and the previous year. See attached.</P></BODY></HTML> Thu, 23 Sep 2010 01:08:56 GMT johnw 2010-09-23T01:08:56Z Problem with Pivot table https://community.qlik.com/t5/QlikView/Problem-with-Pivot-table/m-p/214067#M67663 <HTML><HEAD></HEAD><BODY><P>Hello all.<BR />I have a problem with an expressions in pivot table.<BR />In lines of pivot table I have calculated the Sales of CurrentYear and PreviousYear.<BR />If I show the dimension Year in column, is possible to see the data, like the following example?</P><P>2009 2010 2011</P><P>sales Current Year sales2009 sales2010 sales2011</P><P>sales PreviousYear sales2008 sales2009 sales2010</P><P></P><P>thanks</P><P>Tiziana</P></BODY></HTML> Wed, 22 Sep 2010 15:38:09 GMT https://community.qlik.com/t5/QlikView/Problem-with-Pivot-table/m-p/214067#M67663 tizianacaem 2010-09-22T15:38:09Z Problem with Pivot table https://community.qlik.com/t5/QlikView/Problem-with-Pivot-table/m-p/214068#M67664 <HTML><HEAD></HEAD><BODY><P>I'd handle it with an "AsOf" table linking an AsOfYear to both the current year and the previous year. See attached.</P></BODY></HTML> Thu, 23 Sep 2010 01:08:56 GMT https://community.qlik.com/t5/QlikView/Problem-with-Pivot-table/m-p/214068#M67664 johnw 2010-09-23T01:08:56Z Problem with Pivot table https://community.qlik.com/t5/QlikView/Problem-with-Pivot-table/m-p/214069#M67665 <HTML><HEAD></HEAD><BODY><P>Thank you very much.. it work rightly!!</P></BODY></HTML> Thu, 23 Sep 2010 08:58:53 GMT https://community.qlik.com/t5/QlikView/Problem-with-Pivot-table/m-p/214069#M67665 tizianacaem 2010-09-23T08:58:53Z