topic Difference between two rows in a pivot table & display as columns in QlikView https://community.qlik.com/t5/QlikView/Difference-between-two-rows-in-a-pivot-table-display-as-columns/m-p/1378853#M420617 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/178289_Capture.PNG" style="width: 620px; height: 273px;" /></P><P></P><P>Chart 2 - Final - is the pivoted chart of Original (first) chart.</P><P></P><P>I need to create 3 columns on Final (second) chart displaying the difference between prior n current columns for ABC n DEF.<BR />These columns need to be a:<BR />1) Column 1 = Difference between 201606 n 201609 for ABC n DEF<BR />2) Column 2 = Difference between 201609 n 201612 for ABC n DEF<BR />3) Column 3 = Difference between 201612 n 201703 for ABC n DEF</P><P></P><P>Ideas, please ?</P></BODY></HTML> Mon, 02 Oct 2017 13:00:20 GMT newqlik2017 2017-10-02T13:00:20Z Difference between two rows in a pivot table & display as columns https://community.qlik.com/t5/QlikView/Difference-between-two-rows-in-a-pivot-table-display-as-columns/m-p/1378853#M420617 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/178289_Capture.PNG" style="width: 620px; height: 273px;" /></P><P></P><P>Chart 2 - Final - is the pivoted chart of Original (first) chart.</P><P></P><P>I need to create 3 columns on Final (second) chart displaying the difference between prior n current columns for ABC n DEF.<BR />These columns need to be a:<BR />1) Column 1 = Difference between 201606 n 201609 for ABC n DEF<BR />2) Column 2 = Difference between 201609 n 201612 for ABC n DEF<BR />3) Column 3 = Difference between 201612 n 201703 for ABC n DEF</P><P></P><P>Ideas, please ?</P></BODY></HTML> Mon, 02 Oct 2017 13:00:20 GMT https://community.qlik.com/t5/QlikView/Difference-between-two-rows-in-a-pivot-table-display-as-columns/m-p/1378853#M420617 newqlik2017 2017-10-02T13:00:20Z