Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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
Contributor II

Re: Chart Sum Expression ignoring negative values

Do you want to multify ar1 by var2 and then sum

Not applicable

Re: Chart Sum Expression ignoring negative values

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

Not applicable

Re: Chart Sum Expression ignoring negative values

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

Re: Chart Sum Expression ignoring negative values

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.

MVP
MVP

Re: Chart Sum Expression ignoring negative values

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

];

Highlighted
calvindk
Contributor III

Re: Chart Sum Expression ignoring negative values

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