Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
rajeshqvd
Contributor II

Find Text Give output for next all rows

Hi Need below Output field need to do in Script please help on this if Name = jone after row will return same name until ID<>Previous(ID)

IDNameOUT PUT
111lee 
111assds 
111jonejone
111ssdsjone
111sddjone
111sdsasjone
111saswwjone
222eeee 
222sdsd 
222jonejone
222ddsdjone
222sdddjone
Labels (1)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Find Text Give output for next all rows

Try:

Load *,
	If(ID =Peek(ID), if( Name='jone', 'jone', Peek(Output))) as Output

View solution in original post

1 Reply
Highlighted
MVP
MVP

Re: Find Text Give output for next all rows

Try:

Load *,
	If(ID =Peek(ID), if( Name='jone', 'jone', Peek(Output))) as Output

View solution in original post