topic sum() Question in QlikView

sum() Question

Thu, 14 Feb 2013 06:01:03 GMT

Hello~

I just want to ask why the function sum() doubles up my original value.

what do you think are the causes?

Thanks,

Donna

SunilChauhan — Thu, 14 Feb 2013 06:03:43 GMT

u have duplicates in ur table

if u see frequency of column amountfield then u will understand.

use sum(distinct amountfield)

Thu, 14 Feb 2013 06:10:45 GMT

if i use distinct, it won't tally with the 'total' at the end of the table.

i have tried distinct but end up not equaling with the summed values and the total displayed.

khadeer — Thu, 14 Feb 2013 06:12:06 GMT

Please check the data before joins with other table and after joins. Duplication occurs for joins. It will helps u.

SunilChauhan — Thu, 14 Feb 2013 06:12:40 GMT

can please come up with sample file if possible

Thu, 14 Feb 2013 06:15:14 GMT

alright, i will be checking my script and get back to you. thanks