Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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.

 

Labels (1)
  • sum

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 !

++