topic Re: Calculate difference between data in columns of pivot table. in QlikView https://community.qlik.com/t5/QlikView/Calculate-difference-between-data-in-columns-of-pivot-table/m-p/389156#M568489 <HTML><HEAD></HEAD><BODY><P>diff1-3 = column(1) - column(3) </P></BODY></HTML> Wed, 31 Oct 2012 13:15:38 GMT Gysbert_Wassenaar 2012-10-31T13:15:38Z Calculate difference between data in columns of pivot table. https://community.qlik.com/t5/QlikView/Calculate-difference-between-data-in-columns-of-pivot-table/m-p/389155#M568488 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to calculate difference between two columns/dimensions generated in a pivot table.</P><P></P><P>Thanks in advance for the help</P><P></P><P>Regards,</P><P>Utsav</P></BODY></HTML> Wed, 31 Oct 2012 13:13:43 GMT https://community.qlik.com/t5/QlikView/Calculate-difference-between-data-in-columns-of-pivot-table/m-p/389155#M568488 2012-10-31T13:13:43Z Re: Calculate difference between data in columns of pivot table. https://community.qlik.com/t5/QlikView/Calculate-difference-between-data-in-columns-of-pivot-table/m-p/389156#M568489 <HTML><HEAD></HEAD><BODY><P>diff1-3 = column(1) - column(3) </P></BODY></HTML> Wed, 31 Oct 2012 13:15:38 GMT https://community.qlik.com/t5/QlikView/Calculate-difference-between-data-in-columns-of-pivot-table/m-p/389156#M568489 Gysbert_Wassenaar 2012-10-31T13:15:38Z Re: Calculate difference between data in columns of pivot table. https://community.qlik.com/t5/QlikView/Calculate-difference-between-data-in-columns-of-pivot-table/m-p/389157#M568490 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> If you have two expression and for third expression, you want to calculate the difference between them means, you can use like this</P><P></P><P>=Column(1) - Column(2)</P><P></P><P>But not for dimension..</P><P></P><P>Column(1) takes the first expression used in the straight/pivot table,</P></BODY></HTML> Wed, 31 Oct 2012 13:21:28 GMT https://community.qlik.com/t5/QlikView/Calculate-difference-between-data-in-columns-of-pivot-table/m-p/389157#M568490 MayilVahanan 2012-10-31T13:21:28Z Re: Calculate difference between data in columns of pivot table. https://community.qlik.com/t5/QlikView/Calculate-difference-between-data-in-columns-of-pivot-table/m-p/389158#M568491 <HTML><HEAD></HEAD><BODY><P>Thank You for the valuable inputs.</P></BODY></HTML> Thu, 01 Nov 2012 07:03:25 GMT https://community.qlik.com/t5/QlikView/Calculate-difference-between-data-in-columns-of-pivot-table/m-p/389158#M568491 2012-11-01T07:03:25Z