topic Re: sum is false ??? in App Development

sum is false ???

QlikTonic — Wed, 22 Dec 2021 16:26:04 GMT

I everybody,

I need your help please because i don't understand how it can be possible or what i do wrong :

For each docN° i have a quantity and a sales value (Ventes).

For the docN° 1028 i have quantity : 1 and Ventes : 35... sum(quantite) = 1 and sum(Ventes)=35... tis is correct

For the docN° 12853 i have quantity : 1 and Ventes : 30... sum(quantite) = 2 !!! and sum(Ventes)=60 !!!.. why i have the double !!!????

What did i do wrong please

Thanks for help and good evening !

m_woolf — Tue, 28 May 2019 18:54:39 GMT

It's difficult to be precise without seeing your data and your load script, but it sure looks like you have a duplicate record.

QlikTonic — Tue, 28 May 2019 19:35:12 GMT

i have found it was because of an intervalmatch not state in the art !

Thanks a lot for your help !