Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
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
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
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