Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
norbook_dev
Contributor
Contributor

Sum on graph not correct

I have value in a QVD file e.g

costquantitytotal
80021600
160023200
357027140
480029600
400028000
5600211200
  40740

However I am getting this when I use the sum function

costquantitytotal
80021600
160026400
3570214,280
4800224000
4000219200
5600211200
  177480

Apologies I am new to qlik

This is messing up my graphs

Here is the calculated field

sum(<[field1=,[field2]=, [field3]=[field4]-=[field5]=,[field6]=,[field7]=,[field8]=,[field9]=,[field10]=,[field11]=,[field12]=,[field13]=>}[Snapshot Quantity at Location]*[Snapshot Cost])

3 Replies
Saravanan_Desingh

I could not see any issue while summing. But, can you explain  me more on what you are trying?

commQV42.PNG

MayilVahanan

Hi @norbook_dev 

Reason Might be, in ur data model, if you are doing any join with ur fact table, it cause the data duplicated.

Can you check, ur qvd record count is similar to ur data model table count. 

 

Thanks & Regards,
Mayil Vahanan R
norbook_dev
Contributor
Contributor
Author

Yea sum works ok when I have the table stand alone but when I add in sum it throws off sums

I think maybe Mayil Vahanan R may have a point about the fact table.  We are linking this up.