topic Re: Sum on graph not correct in QlikView

Sum on graph not correct

norbook_dev — Wed, 10 Mar 2021 17:21:35 GMT

I have value in a QVD file e.g

cost	quantity	total
800	2	1600
1600	2	3200
3570	2	7140
4800	2	9600
4000	2	8000
5600	2	11200
		40740

However I am getting this when I use the sum function

cost	quantity	total
800	2	1600
1600	2	6400
3570	2	14,280
4800	2	24000
4000	2	19200
5600	2	11200
		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])

Re: Sum on graph not correct

Saravanan_Desingh — Thu, 11 Mar 2021 02:29:23 GMT

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

Re: Sum on graph not correct

MayilVahanan — Thu, 11 Mar 2021 06:37:21 GMT

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.

Re: Sum on graph not correct

norbook_dev — Thu, 11 Mar 2021 10:08:25 GMT

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.