Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multinested previous()?

Hi All,

I've got a dataset with 2 columns where some records miss value in the first column. In these very records where values are missed I want to assign last value in the first column as shown below. I guess prevoius() will not work here. Do you have an idea how to solve it?

Regards,

Przemek

INPUT

---------

Name, City

John, Berlin

Mary, London

, Paris

, Amsterdam

OUTPUT

-------------

Name, City

John, Berlin

Mary, London

Mary, Paris

Mary, Amsterdam

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

Yup.

If(Len(Trim(Name))=0,Peek(Name),Name) as Name

HIC

View solution in original post

2 Replies
hic
Former Employee
Former Employee

Yup.

If(Len(Trim(Name))=0,Peek(Name),Name) as Name

HIC

Not applicable
Author

Thank you, Henric.