Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart Sum Expression ignoring negative values

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:sumerror.png

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

6 Replies
upaliwije
Creator II
Creator II

Do you want to multify ar1 by var2 and then sum

Not applicable
Author

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

Not applicable
Author

I dont have the qlikview file.

What is suposed to happen is:

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

Not applicable
Author

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
MVP
MVP

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
Creator III
Creator III

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