topic Sum function problem in QlikView https://community.qlik.com/t5/QlikView/Sum-function-problem/m-p/1009081#M645260 <HTML><HEAD></HEAD><BODY><P>My problem is that i want to get the sum of my colums <STRONG>a</STRONG> and <STRONG>b</STRONG> but when i use the sum function to get the total of these columns in a textbox. I get a false total.</P><P>How can i bypass my problem and get the total of the colums in the textbox?<IMG alt="Unbenannt.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/107640_Unbenannt.PNG" style="height: 502px; width: 620px;" /></P></BODY></HTML> Mon, 30 Nov 2015 15:38:14 GMT 2015-11-30T15:38:14Z Sum function problem https://community.qlik.com/t5/QlikView/Sum-function-problem/m-p/1009081#M645260 <HTML><HEAD></HEAD><BODY><P>My problem is that i want to get the sum of my colums <STRONG>a</STRONG> and <STRONG>b</STRONG> but when i use the sum function to get the total of these columns in a textbox. I get a false total.</P><P>How can i bypass my problem and get the total of the colums in the textbox?<IMG alt="Unbenannt.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/107640_Unbenannt.PNG" style="height: 502px; width: 620px;" /></P></BODY></HTML> Mon, 30 Nov 2015 15:38:14 GMT https://community.qlik.com/t5/QlikView/Sum-function-problem/m-p/1009081#M645260 2015-11-30T15:38:14Z Re: Sum function problem https://community.qlik.com/t5/QlikView/Sum-function-problem/m-p/1009082#M645261 <HTML><HEAD></HEAD><BODY><P>Try it this way:</P><P></P><P><STRONG>Sum(Aggr(If(BundgeProzent &gt;100, 1, 0), <SPAN style="color: #ff0000;">yourChartDimensions</SPAN>))</STRONG></P><P></P><P>list all dimensions where you see <STRONG style="color: #ff0000; font-size: 13.3333px;">yourChartDimensions </STRONG>in the expression above</P></BODY></HTML> Mon, 30 Nov 2015 17:01:39 GMT https://community.qlik.com/t5/QlikView/Sum-function-problem/m-p/1009082#M645261 sunny_talwar 2015-11-30T17:01:39Z