Discussion Board for collaboration related to QlikView App Development.
I have a table like this:
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
4, B B
How can do it as easy as possible?
If( Len(Trim(Field2)), Field2, Peek(Field3) ) as Field3
View solution in original post
Re: Fill column value with previous not null value
Generating missing data.pdf
Fill empty cells with value from "above"
If(Len(Trim(Field2)) > 0, Field2, Peek('Field3')) as Field3;
LOAD * Inline [