topic SUM() Function: How to avoid duplicate numbers? in QlikView https://community.qlik.com/t5/QlikView/SUM-Function-How-to-avoid-duplicate-numbers/m-p/165473#M37761 <HTML><HEAD></HEAD><BODY><P>Greetings everyone!<BR /><BR />Another noob doubt...</P><P>I'm using a SUM() function to bring total values grouped by a code, and even using the DISTINCT clause, it brings me a lot of duplicate values, each one of these related to different records... Here is a sample of the report itself...</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3251_sourceID:3251" /></P><P>...And the code I wrote for it:</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3252_sourceID:3252" /></P><P></P><P>Where am I going wrong?</P><P>Thx in advance!</P></BODY></HTML> Wed, 12 Jan 2011 13:14:27 GMT 2011-01-12T13:14:27Z SUM() Function: How to avoid duplicate numbers? https://community.qlik.com/t5/QlikView/SUM-Function-How-to-avoid-duplicate-numbers/m-p/165473#M37761 <HTML><HEAD></HEAD><BODY><P>Greetings everyone!<BR /><BR />Another noob doubt...</P><P>I'm using a SUM() function to bring total values grouped by a code, and even using the DISTINCT clause, it brings me a lot of duplicate values, each one of these related to different records... Here is a sample of the report itself...</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3251_sourceID:3251" /></P><P>...And the code I wrote for it:</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3252_sourceID:3252" /></P><P></P><P>Where am I going wrong?</P><P>Thx in advance!</P></BODY></HTML> Wed, 12 Jan 2011 13:14:27 GMT https://community.qlik.com/t5/QlikView/SUM-Function-How-to-avoid-duplicate-numbers/m-p/165473#M37761 2011-01-12T13:14:27Z SUM() Function: How to avoid duplicate numbers? https://community.qlik.com/t5/QlikView/SUM-Function-How-to-avoid-duplicate-numbers/m-p/165474#M37762 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>maybe there are more decimals, because if this value 11,06 is the same for the 3 Shippers, Qlikview will show it as 11,06 in only one row, and if you check the frecuency, it will show you 3</P><P>try changing the number of decimals and see what happens</P><P>Rgds</P></BODY></HTML> Wed, 12 Jan 2011 13:26:40 GMT https://community.qlik.com/t5/QlikView/SUM-Function-How-to-avoid-duplicate-numbers/m-p/165474#M37762 hector 2011-01-12T13:26:40Z SUM() Function: How to avoid duplicate numbers? https://community.qlik.com/t5/QlikView/SUM-Function-How-to-avoid-duplicate-numbers/m-p/165475#M37763 <HTML><HEAD></HEAD><BODY><P>Hello again Héctor!</P><P>You are absolutely right... I raised the decimal precision to 8, and it worked.</P><P>My datasources are very messed up... there's no control upon its input.</P><P>Thanx for the flash-answer!</P></BODY></HTML> Wed, 12 Jan 2011 13:38:17 GMT https://community.qlik.com/t5/QlikView/SUM-Function-How-to-avoid-duplicate-numbers/m-p/165475#M37763 2011-01-12T13:38:17Z