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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 !

++