QlikSense Strange Sum Calculation

[Ron1]

I am facing a very strange issue where after loading my data, if I calculate my measure manually it gives a result. But when Qlik is calculating the same, it is giving different result.

Please see attached

snap where Hours 26 and 30 is getting calculated as 52 and 150. I am not getting any clue. 

Can anyone please help

[lironbaram · Accepted solution]

Hi

usually this means you have duplicated records with the same dimensions 

[Vegar · Accepted solution]

Ås @lironbaram wrote,  it's most likely duplicate rows that is causing your mismatch between Hours and Sum(Hours).

Try creating a measure like  count(Hours) or count(Level)  to see how many records are included to your sum.