topic Re: QlikSense Strange Sum Calculation in App Development

QlikSense Strange Sum Calculation

Ron1 — Sat, 02 Nov 2019 13:59:09 GMT

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

Re: QlikSense Strange Sum Calculation

lironbaram — Sat, 02 Nov 2019 19:07:52 GMT

usually this means you have duplicated records with the same dimensions

Re: QlikSense Strange Sum Calculation

Vegar — Sat, 02 Nov 2019 22:33:03 GMT

Å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.