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!
