topic Re: What is different of Sum and Only function? in QlikView https://community.qlik.com/t5/QlikView/What-is-different-of-Sum-and-Only-function/m-p/338231#M124725 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Both functions are quiet different.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; The 'Sum' function calculates the addition of more than one values given in the rows while the 'only' function returns only one value depending on your selection.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; And the number of values provided to the function also differs. The Only function accepts one value while the sum function accepts specified set of values to calculate the sum.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; In case, if you are providing only one value for both the functions as a parameter, obviously both the functions will give the same result.&nbsp; </P><P></P><P>Regards</P><P>Andrew</P></BODY></HTML> Thu, 05 Apr 2012 02:13:26 GMT adhudson 2012-04-05T02:13:26Z What is different of Sum and Only function? https://community.qlik.com/t5/QlikView/What-is-different-of-Sum-and-Only-function/m-p/338230#M124724 <HTML><HEAD></HEAD><BODY><P>What is different of Sum and Only&nbsp; in Aggregate function?</P><P>Can someone give me some example.</P><P>Thanks</P></BODY></HTML> Thu, 05 Apr 2012 02:00:15 GMT https://community.qlik.com/t5/QlikView/What-is-different-of-Sum-and-Only-function/m-p/338230#M124724 2012-04-05T02:00:15Z Re: What is different of Sum and Only function? https://community.qlik.com/t5/QlikView/What-is-different-of-Sum-and-Only-function/m-p/338231#M124725 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Both functions are quiet different.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; The 'Sum' function calculates the addition of more than one values given in the rows while the 'only' function returns only one value depending on your selection.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; And the number of values provided to the function also differs. The Only function accepts one value while the sum function accepts specified set of values to calculate the sum.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; In case, if you are providing only one value for both the functions as a parameter, obviously both the functions will give the same result.&nbsp; </P><P></P><P>Regards</P><P>Andrew</P></BODY></HTML> Thu, 05 Apr 2012 02:13:26 GMT https://community.qlik.com/t5/QlikView/What-is-different-of-Sum-and-Only-function/m-p/338231#M124725 adhudson 2012-04-05T02:13:26Z