topic Re: Chart Sum Expression ignoring negative values in QlikView

Chart Sum Expression ignoring negative values

Fri, 30 May 2014 13:24:15 GMT

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

Re: Chart Sum Expression ignoring negative values

upaliwije — Fri, 30 May 2014 13:28:25 GMT

Do you want to multify ar1 by var2 and then sum

Re: Chart Sum Expression ignoring negative values

Fri, 30 May 2014 13:29:13 GMT

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

Re: Chart Sum Expression ignoring negative values

Fri, 30 May 2014 13:31:52 GMT

I dont have the qlikview file.

What is suposed to happen is:

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

Re: Chart Sum Expression ignoring negative values

Fri, 30 May 2014 13:40:15 GMT

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.

Re: Chart Sum Expression ignoring negative values

maxgro — Fri, 30 May 2014 13:43:49 GMT

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

example (result is 101)

load * inline [

field1, var1

1,100

2,1

3,-100

];

load * inline [

field1,var2

1,1

2,1

];

Re: Chart Sum Expression ignoring negative values

calvindk — Fri, 30 May 2014 13:58:56 GMT

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