Chart Sum Expression ignoring negative values

[#1]

Hello all,

This is my first post in this community, so i apologise if i am not being crystal clear with what i am going to say.

I have a Pivot Table chart type, in wich i have an expression labeled by "FINAL VAR" defined by this :

     =SUM([VAR1]*[VAR2])

Each variable (var1 and var2) comes from diferent tables, and what happens is the following:

For some reason the SUM function used in the expression is not considering the negative value -10071.9 and is giving me the output that you can see.

Please any help or sugestion would be nice.

Best Regards,

Fernando

[upaliwije]

Do you want to multify ar1 by var2 and then sum

[#3]

Do you have your qlikview file? The picture might not be enough to solve your problem.

[#4]

I dont have the qlikview file.

What is suposed to happen is:

(1*-10071.9)+(1*2316.54)+(1*10071.9)=2316.54

[#5]

I agree with Jacob, it is odd that your expression isn't working.  But without your qvw or even your data set it'll be difficult for anyone to help.

[maxgro]

perhaps you have some nulls or missing record in the table with var1

example (result is 101)

a:

load * inline [

field1, var1

1,100

2,1

3,-100

];

b:

load * inline [

field1,var2

1,1

2,1

];

[calvindk]

My guess would be that 10071,9 exists twice in the underlying data!