Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikTonic
Contributor III
Contributor III

sum is false ???

I everybody,

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

qlik sum.PNG

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 !

C.

 

2 Replies
m_woolf
Master II
Master II

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
Contributor III
Contributor III
Author

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

Thanks a lot for your help !

++