topic Re: Prob in Rangesum !! in QlikView

Prob in Rangesum !!

nikhilgarg — Wed, 17 Dec 2014 06:46:01 GMT

HEy,

In following Range function , if we use any numeric value like in first case then will it olways give sum??

And also in second case if we use character with numeric , will it olways give number ??

	rangesum (1,2,4)	returns 7
	rangesum (1,'xyz')	returns 1

anbu1984 — Wed, 17 Dec 2014 07:12:17 GMT

rangesum (1,'1xyz') returns 1

saumyashah90 — Wed, 17 Dec 2014 07:23:13 GMT

When you use RangeSum()

It treats all Non Numeric values as 0.

So rangesum(1,'xyz') = rangesum(1,0) both will return 1

nikhilgarg — Wed, 17 Dec 2014 07:47:18 GMT

HEy,

Thanks