topic Re: Calculations not in all rows in QlikView

Calculations not in all rows

yura_ratu — Tue, 06 May 2014 12:32:35 GMT

Hello guys,

When I try to make arithmetic operations with values in rows result is calculated only in rows where exist every part of expression. Here is example

sample:

load * inline [

ID, T1, T2

1, 1, 1

2, , 1

3, 1, 1

4, 1,

]

;

Left Join (sample)

LOAD

ID,

T1+T2 as SUM

Resident sample

;

Result is

How can calculate sum for every row? So, for ID 2 and 4 it should be 1

tresB — Tue, 06 May 2014 12:38:07 GMT

Instead of

.....

T1+T2 as SUM

try like:

RangeSum(T1, T2) as SUM

jagannalla — Tue, 06 May 2014 12:41:52 GMT

Try this.