topic Re: How to operate with columns in a pivot table in QlikView https://community.qlik.com/t5/QlikView/How-to-operate-with-columns-in-a-pivot-table/m-p/145442#M24162 <HTML><HEAD></HEAD><BODY><P>column(1) + coloumn(2)</P><P></P><P>paranthesis indicate which column you are trying to refer to.</P></BODY></HTML> Tue, 08 Oct 2013 06:22:01 GMT 2013-10-08T06:22:01Z How to operate with columns in a pivot table https://community.qlik.com/t5/QlikView/How-to-operate-with-columns-in-a-pivot-table/m-p/145437#M24157 <HTML><HEAD></HEAD><BODY><P>Hi, i'm new in QV, i have found this questions but i haven't found it, i think it must be simply.</P><P>I have a pivot table with two colums that each one contains a formula and i need a third column that for example multiplies the other, how can I reference? I have tried to put (column1 + column2) but it shows in the column the text "column1 + column2" not the value of the operation.</P><P>Thanks</P><P></P></BODY></HTML> Fri, 29 May 2009 17:28:10 GMT https://community.qlik.com/t5/QlikView/How-to-operate-with-columns-in-a-pivot-table/m-p/145437#M24157 2009-05-29T17:28:10Z How to operate with columns in a pivot table https://community.qlik.com/t5/QlikView/How-to-operate-with-columns-in-a-pivot-table/m-p/145438#M24158 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>just use that expression name in the third expression.</P><P>For example your</P><P>1st expression is <B>sum(Sales)</B> and lable is <B>Sales</B>.</P><P>2nd expression is <B>sum(Total Sales)</B> and lable is <B>Total_Sales.</B></P><P>3rd expression would be the name of the <B>1st and 2nd</B> expression i.e. <B>Sales + Total_Sales.</B></P><P>Check the attachment. <B><BR /></B></P><P></P><P style="font-weight: bold">- Sridhar</P><P></P></BODY></HTML> Fri, 29 May 2009 17:56:49 GMT https://community.qlik.com/t5/QlikView/How-to-operate-with-columns-in-a-pivot-table/m-p/145438#M24158 2009-05-29T17:56:49Z How to operate with columns in a pivot table https://community.qlik.com/t5/QlikView/How-to-operate-with-columns-in-a-pivot-table/m-p/145439#M24159 <HTML><HEAD></HEAD><BODY><P>Ok, i will try it step by step.</P><P>Thanks</P></BODY></HTML> Fri, 29 May 2009 18:11:36 GMT https://community.qlik.com/t5/QlikView/How-to-operate-with-columns-in-a-pivot-table/m-p/145439#M24159 2009-05-29T18:11:36Z How to operate with columns in a pivot table https://community.qlik.com/t5/QlikView/How-to-operate-with-columns-in-a-pivot-table/m-p/145440#M24160 <HTML><HEAD></HEAD><BODY><P>Hi Raghu, This was interesting. I never figured this out till now.</P><P>I would have mentioned my 3rd expression as '=column(1) + column(2)' and a label explicitly mentioned.</P><P>Thanks, Amit.</P></BODY></HTML> Fri, 29 May 2009 18:25:50 GMT https://community.qlik.com/t5/QlikView/How-to-operate-with-columns-in-a-pivot-table/m-p/145440#M24160 amit_shetty78 2009-05-29T18:25:50Z How to operate with columns in a pivot table https://community.qlik.com/t5/QlikView/How-to-operate-with-columns-in-a-pivot-table/m-p/145441#M24161 <HTML><HEAD></HEAD><BODY><P>Easiest way</P><P>=column(1) + column(2)</P><P></P><P>The key is the ()</P></BODY></HTML> Sat, 30 May 2009 00:48:16 GMT https://community.qlik.com/t5/QlikView/How-to-operate-with-columns-in-a-pivot-table/m-p/145441#M24161 james 2009-05-30T00:48:16Z Re: How to operate with columns in a pivot table https://community.qlik.com/t5/QlikView/How-to-operate-with-columns-in-a-pivot-table/m-p/145442#M24162 <HTML><HEAD></HEAD><BODY><P>column(1) + coloumn(2)</P><P></P><P>paranthesis indicate which column you are trying to refer to.</P></BODY></HTML> Tue, 08 Oct 2013 06:22:01 GMT https://community.qlik.com/t5/QlikView/How-to-operate-with-columns-in-a-pivot-table/m-p/145442#M24162 2013-10-08T06:22:01Z