Issue with Sum function in Qliksense

[pthai]

Hi everyone,

I met an issue with the sum function.

I have 2 data rows as the image. 

The column 1 and 2 are dimension. But when I use the sum in column 3, it show duplicate value.

Could anyone explan to me what is the reason for this? Thank in advance.

[G3S]

try sum(distinct 

[pthai]

Thanks. But I want to know why the sum of dimension shown duplicated value. Its weird!

[Gabbar · Accepted solution]

For sum getting double its data is two times in loaded table.
also
There is atleast 1 another dimension column in that table 
or the values in those dimension are numerical timestamp but made into integere which means those are different values but you cant see them unless you format them correctly, try using floor for this case.

[pthai]

Thank Gabbar,

I use the disinct load and the issue was solved.