topic How to get sum of all dynamic column values in a separate field in QlikView https://community.qlik.com/t5/QlikView/How-to-get-sum-of-all-dynamic-column-values-in-a-separate-field/m-p/271817#M1179079 <HTML><HEAD></HEAD><BODY><P>Have you tried with a total column (enable Partial sum in presentation tab)?</P></BODY></HTML> Fri, 10 Feb 2012 13:28:45 GMT swuehl 2012-02-10T13:28:45Z How to get sum of all dynamic column values in a separate field https://community.qlik.com/t5/QlikView/How-to-get-sum-of-all-dynamic-column-values-in-a-separate-field/m-p/271813#M1179075 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: mceinline;"> </SPAN><SPAN style="font-family: mceinline;"> </SPAN><SPAN style="font-family: mceinline;"> </SPAN><SPAN style="font-family: mceinline;"> </SPAN></P><P></P><P>Hello All,</P><P></P><P>I have created Pivot Table Report. Please find the attached screen sheet. If I select start date and end date then the report will display the sum of Actual and norm values for each week by displaying weekstart date on the top. </P><P></P><P>I also want to add one more column which shows sum of Actual and Norm values for all weeks that are displayed on the report.</P><P></P><P>Helpful answer would be appreciated.</P><P></P><P></P><P>Thanks in Advance!!! </P></BODY></HTML> Fri, 10 Feb 2012 12:51:01 GMT https://community.qlik.com/t5/QlikView/How-to-get-sum-of-all-dynamic-column-values-in-a-separate-field/m-p/271813#M1179075 2012-02-10T12:51:01Z How to get sum of all dynamic column values in a separate field https://community.qlik.com/t5/QlikView/How-to-get-sum-of-all-dynamic-column-values-in-a-separate-field/m-p/271814#M1179076 <HTML><HEAD></HEAD><BODY><P>Just add one more expression as Actual+Norm and give label name what you want.</P></BODY></HTML> Fri, 10 Feb 2012 12:58:41 GMT https://community.qlik.com/t5/QlikView/How-to-get-sum-of-all-dynamic-column-values-in-a-separate-field/m-p/271814#M1179076 jagannalla 2012-02-10T12:58:41Z Re: How to get sum of all dynamic column values in a separate field https://community.qlik.com/t5/QlikView/How-to-get-sum-of-all-dynamic-column-values-in-a-separate-field/m-p/271815#M1179077 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; You can use the expression for actual+normal like this</P><P>&nbsp;&nbsp;&nbsp;&nbsp; =Column(2)+Column(3)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Assuming that your actual is 2nd expression(so i used Column(2)) and norm is 3rd expression(so Column(3)).</P><P></P><P>Hope it helps</P><P>Celambarasan</P></BODY></HTML> Fri, 10 Feb 2012 13:07:21 GMT https://community.qlik.com/t5/QlikView/How-to-get-sum-of-all-dynamic-column-values-in-a-separate-field/m-p/271815#M1179077 CELAMBARASAN 2012-02-10T13:07:21Z How to get sum of all dynamic column values in a separate field https://community.qlik.com/t5/QlikView/How-to-get-sum-of-all-dynamic-column-values-in-a-separate-field/m-p/271816#M1179078 <HTML><HEAD></HEAD><BODY><P>Thanks for you reply...You would have understood in different way...Actually i want sum of actual values for all weeks that are displayed on the report in one column and sum of norm values for all weeks that are displayed on the report in different column</P></BODY></HTML> Fri, 10 Feb 2012 13:24:50 GMT https://community.qlik.com/t5/QlikView/How-to-get-sum-of-all-dynamic-column-values-in-a-separate-field/m-p/271816#M1179078 2012-02-10T13:24:50Z How to get sum of all dynamic column values in a separate field https://community.qlik.com/t5/QlikView/How-to-get-sum-of-all-dynamic-column-values-in-a-separate-field/m-p/271817#M1179079 <HTML><HEAD></HEAD><BODY><P>Have you tried with a total column (enable Partial sum in presentation tab)?</P></BODY></HTML> Fri, 10 Feb 2012 13:28:45 GMT https://community.qlik.com/t5/QlikView/How-to-get-sum-of-all-dynamic-column-values-in-a-separate-field/m-p/271817#M1179079 swuehl 2012-02-10T13:28:45Z