topic Re: Sum doesn't work in Straight Table in QlikView

Sum doesn't work in Straight Table

anuradhaa — Wed, 25 Nov 2020 16:16:04 GMT

I'm using view to load data.

it has two colums in number data type.

After load the data i use above two columns to add them together in expression. but some records were not available in the grid.

ex- when id = 120, both columns has ' 0 ' data that records is not available.

Re: Sum doesn't work in Straight Table

Anil_Babu_Samineni — Wed, 12 Apr 2017 06:49:42 GMT

May be use RanguSum(Column1, Column2)

Or you should show data and expected result

Re: Sum doesn't work in Straight Table

anuradhaa — Wed, 12 Apr 2017 06:59:12 GMT

I found the issue,

I use Val1 + Val 2 in my expression,

use if((Val1 + Val 2)>0,(Val1 + Val 2),'0.00').

but when i use this, that raw doesn't show.

but use if((Val1 + Val 2)>0,(Val1 + Val 2),'www').

it shows 'www' when val1 and val2 is 0.

Val1 + Val 2 also don't show any record

Re: Sum doesn't work in Straight Table

jonathandienst — Wed, 12 Apr 2017 07:21:19 GMT

Not sure if I understand your issue, but I think what you need is this expression:

=RangeMax(RangeSum(Val1, Val2), 0)

The RangeSum ensures that a null value in either field does not result in a null result. The RangeMax replaces your If() and returns only the positive values.

Re: Sum doesn't work in Straight Table

gerry_hdm — Wed, 12 Apr 2017 07:26:18 GMT

In the table

sum( rangesum(VAr1,Var2)

or In the script

rangesum(VAr1,Var2) as #nameSumVAr

and then in Table

sum(#nameSumVAr)

Gruß gerold

Re: Sum doesn't work in Straight Table

Siva_Sankar — Wed, 12 Apr 2017 08:39:32 GMT

Anuradha,

Not sure if i understand your issue correctly, if you are talking about total row at the bottom..check if you enabled Sum of Rows instead of Expression Total under the Expression tab.

Re: Sum doesn't work in Straight Table

Anil_Babu_Samineni — Wed, 12 Apr 2017 08:44:21 GMT

but use if((Val1 + Val 2)>0,(Val1 + Val 2),'www').

it shows 'www' when val1 and val2 is 0.

Because, Here you are taking only o above data. If you want to calculate with 0 then expression should this

if((Val1 + Val 2)>=0,(Val1 + Val 2),'www')