Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Multinested previous()?

Yup.

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

HIC

2 Replies

Re: Multinested previous()?

Yup.

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

HIC

Not applicable

Re: Multinested previous()?

Thank you, Henric.