topic Re: Straight table Expression in QlikView

Straight table Expression

srikantj — Wed, 22 Mar 2017 15:13:00 GMT

Hi Qlikss

I have straight table with columns

id ,name, description, quantity, goods ,column(4)+column(5)

i have total 1000 rows. the last expression column(4)+column(5). is giving right results for almost 995 rows

but for that 5 rows it is showing nulls. which is not correct. this is very simple sum and i am loading data from excel

how can it go wrong for only 4 or 5 rows. is there anything wrong with straight table.

Suggest me...

sunny_talwar — Wed, 22 Mar 2017 15:14:41 GMT

Try with RangeSum()

RangeSum(Column(4), Column(5))

srikantj — Wed, 22 Mar 2017 15:16:14 GMT

why it wont work with normal sum sunny..

srikantj — Wed, 22 Mar 2017 15:18:54 GMT

Thanks.. but why it won't work with normal sum when my formula is correct

sunny_talwar — Wed, 22 Mar 2017 15:22:46 GMT

Because if one of the two columns have null in them, + won't be able to sum number with a null. But RangeSum() will sum regardless of the nulls.