Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
GeromA
Contributor II
Contributor II

Aggregation Error - subtracting values instead of summing up

Hello Community,

following error occurred in my Qlik Sense table.

While the individual values are positive, I'd expected them to add up in order to gain a total. Instead, values are subtracted. My Pivot Table looks like this:

LEVEL1 LEVEL2 LEVEL3 LEVEL4 LEVEL5 LEVEL6 num#(left(DATE,4)) Year
DATA1 TOTAL         -26.398,05 €
DATA2 TOTAL       -26.398,05 €
DATA3 TOTAL     -26.398,05 €
DATA4 TOTAL   -26.398,05 €
DATA5 TOTAL -26.398,05 €
DATA6 1.210.385,90 €
DATA6

1.236.783,95 €

Any ideas???

Many thanks!

Labels (3)
0 Replies