topic Re: Fill a field when empty with previous value in QlikView

Fill a field when empty with previous value

Thu, 07 Apr 2016 17:22:32 GMT

I have a table like this:

Field1, Field2

1, A

4, B

So field2 is empty in rows 2,3 and 5.

I wish to get a field3 where if row in field2 is empty it takes the value before in field3, and if not it takes the value in field2, resulting this:

Field1, Field2, Field3

1, A A

2, A

3, A

4, B B

5, B

How can do it as easy as possible?

Thnaks

Chanty4u — Thu, 07 Apr 2016 17:24:39 GMT

chk dis

swuehl — Thu, 07 Apr 2016 17:24:43 GMT

Maybe like

LOAD Field1,

If( Len(Trim(Field2)), Field2, Peek(Field3) ) as Field3

FROM YourTable;

Chanty4u — Thu, 07 Apr 2016 17:25:27 GMT

hi,

sunny_talwar — Thu, 07 Apr 2016 17:25:45 GMT

Try this:

Table:

LOAD Field1,

Field2,

If(Len(Trim(Field2)) > 0, Field2, Peek('Field3')) as Field3;

LOAD * Inline [

Field1, Field2

1, A

4, B

];