topic Re: two extra columns in pivot table in QlikView https://community.qlik.com/t5/QlikView/two-extra-columns-in-pivot-table/m-p/691604#M1062739 <HTML><HEAD></HEAD><BODY><P>Is someone to suggest</P></BODY></HTML> Thu, 25 Sep 2014 09:04:00 GMT 2014-09-25T09:04:00Z two extra columns in pivot table https://community.qlik.com/t5/QlikView/two-extra-columns-in-pivot-table/m-p/691601#M1062736 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need two columns one is for DualYearDIff and the Other is TotalYearDiff</P><P>in those columns i need the difference of the values in 2013 and 2012 ie 2013-2012 =7096-964 = 6132</P><P>and 2014-2013 and 2012 should be empty because it has no previous value</P><P>the same procedure to the TotalYearDiff column as well</P><P></P><P>i am sharing the app</P></BODY></HTML> Thu, 25 Sep 2014 07:29:37 GMT https://community.qlik.com/t5/QlikView/two-extra-columns-in-pivot-table/m-p/691601#M1062736 2014-09-25T07:29:37Z Re: two extra columns in pivot table https://community.qlik.com/t5/QlikView/two-extra-columns-in-pivot-table/m-p/691602#M1062737 <HTML><HEAD></HEAD><BODY><P>Hope this is what you are looking for, attached QVW.</P><P></P><P>Regards,</P><P>Raksha</P></BODY></HTML> Thu, 25 Sep 2014 08:05:07 GMT https://community.qlik.com/t5/QlikView/two-extra-columns-in-pivot-table/m-p/691602#M1062737 2014-09-25T08:05:07Z Re: two extra columns in pivot table https://community.qlik.com/t5/QlikView/two-extra-columns-in-pivot-table/m-p/691603#M1062738 <HTML><HEAD></HEAD><BODY><P>I need like this</P><P><IMG alt="Capture.PNG.png" class="jive-image jiveImage" src="https://community.qlik.com/legacyfs/online/67638_Capture.PNG.png" /></P><P>I need the Dual YOY to be like this but i hard coded the values here , i need them to be logical</P></BODY></HTML> Thu, 25 Sep 2014 08:21:38 GMT https://community.qlik.com/t5/QlikView/two-extra-columns-in-pivot-table/m-p/691603#M1062738 2014-09-25T08:21:38Z Re: two extra columns in pivot table https://community.qlik.com/t5/QlikView/two-extra-columns-in-pivot-table/m-p/691604#M1062739 <HTML><HEAD></HEAD><BODY><P>Is someone to suggest</P></BODY></HTML> Thu, 25 Sep 2014 09:04:00 GMT https://community.qlik.com/t5/QlikView/two-extra-columns-in-pivot-table/m-p/691604#M1062739 2014-09-25T09:04:00Z