Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

sum() Question

Hello~

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

what do you think are the causes?

Thanks,

Donna

Tags (1)
5 Replies
chauhans85
Esteemed Contributor

Re: sum() Question

u have  duplicates in ur table

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

use sum(distinct amountfield)

Not applicable

Re: sum() Question

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_sparks
Valued Contributor

Re: sum() Question

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

chauhans85
Esteemed Contributor

Re: sum() Question

can please come up with sample file if possible

Not applicable

Re: sum() Question

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

Community Browser