topic Re: Pivot table: Percentage difference between columns on the same dimension in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-Percentage-difference-between-columns-on-the-same/m-p/1155759#M519822 <HTML><HEAD></HEAD><BODY><P>The result is ok.</P></BODY></HTML> Tue, 09 Aug 2016 14:09:15 GMT marcobombo 2016-08-09T14:09:15Z Pivot table: Percentage difference between columns on the same dimension https://community.qlik.com/t5/QlikView/Pivot-table-Percentage-difference-between-columns-on-the-same/m-p/1155755#M519813 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have this problem. I want to make the percentage difference between the columns in a pivot table on the same dimension (Year).</P><P>It is possible?</P><P></P><P>I attache the example.</P><P></P><P>Thanks</P></BODY></HTML> Tue, 09 Aug 2016 10:16:25 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Percentage-difference-between-columns-on-the-same/m-p/1155755#M519813 marcobombo 2016-08-09T10:16:25Z Re: Pivot table: Percentage difference between columns on the same dimension https://community.qlik.com/t5/QlikView/Pivot-table-Percentage-difference-between-columns-on-the-same/m-p/1155756#M519815 <HTML><HEAD></HEAD><BODY><P><STRONG>Before(sum(Value))</STRONG> will bring you the value of left column</P></BODY></HTML> Tue, 09 Aug 2016 11:44:15 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Percentage-difference-between-columns-on-the-same/m-p/1155756#M519815 Clever_Anjos 2016-08-09T11:44:15Z Re: Pivot table: Percentage difference between columns on the same dimension https://community.qlik.com/t5/QlikView/Pivot-table-Percentage-difference-between-columns-on-the-same/m-p/1155757#M519817 <HTML><HEAD></HEAD><BODY><P><STRONG>1-Before(sum(Value))/sum(Value)</STRONG> returns the variation</P></BODY></HTML> Tue, 09 Aug 2016 11:45:35 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Percentage-difference-between-columns-on-the-same/m-p/1155757#M519817 Clever_Anjos 2016-08-09T11:45:35Z Re: Pivot table: Percentage difference between columns on the same dimension https://community.qlik.com/t5/QlikView/Pivot-table-Percentage-difference-between-columns-on-the-same/m-p/1155758#M519819 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/134032_Capture.PNG" style="height: 280px; width: 620px;" /></P><P></P><P>Probably too many hard-corded value and can somehow be automated</P></BODY></HTML> Tue, 09 Aug 2016 11:50:29 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Percentage-difference-between-columns-on-the-same/m-p/1155758#M519819 sunny_talwar 2016-08-09T11:50:29Z Re: Pivot table: Percentage difference between columns on the same dimension https://community.qlik.com/t5/QlikView/Pivot-table-Percentage-difference-between-columns-on-the-same/m-p/1155759#M519822 <HTML><HEAD></HEAD><BODY><P>The result is ok.</P></BODY></HTML> Tue, 09 Aug 2016 14:09:15 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Percentage-difference-between-columns-on-the-same/m-p/1155759#M519822 marcobombo 2016-08-09T14:09:15Z