Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MarioS
Contributor II
Contributor II

Fill rows based on first Row

Dear QLikers, 

Below is my question, I need to transform the below in the script in think i need to use a peek function, I would appreciate if you can help with its syntax:  Thank you!!!

Input:

Date Stage
08/12/2019 15:46:00-
08/12/2019 15:47:00-
08/12/2019 15:48:00Navigation
08/12/2019 15:49:00-
08/12/2019 15:50:00-
08/12/2019 15:51:00-
08/12/2019 15:52:00-
08/12/2019 15:53:00-
08/12/2019 15:54:00-
08/12/2019 15:55:00-
08/12/2019 15:56:00-
08/12/2019 15:57:00-
08/12/2019 15:58:00-
08/12/2019 15:59:00-
08/12/2019 16:00:00-
08/12/2019 16:01:00Maneuvering 
08/12/2019 16:02:00-
08/12/2019 16:03:00-
08/12/2019 16:04:00-
08/12/2019 16:05:00-
08/12/2019 16:06:00-

 

Output:

Date Stage
08/12/2019 15:46:00-
08/12/2019 15:47:00-
08/12/2019 15:48:00Navigation
08/12/2019 15:49:00Navigation
08/12/2019 15:50:00Navigation
08/12/2019 15:51:00Navigation
08/12/2019 15:52:00Navigation
08/12/2019 15:53:00Navigation
08/12/2019 15:54:00Navigation
08/12/2019 15:55:00Navigation
08/12/2019 15:56:00Navigation
08/12/2019 15:57:00Navigation
08/12/2019 15:58:00Navigation
08/12/2019 15:59:00Navigation
08/12/2019 16:00:00Navigation
08/12/2019 16:01:00Maneuvering
08/12/2019 16:02:00Maneuvering
08/12/2019 16:03:00Maneuvering
08/12/2019 16:04:00Maneuvering
08/12/2019 16:05:00Maneuvering
08/12/2019 16:06:00Maneuvering
Labels (1)
1 Reply
Gui_Approbato
Creator II
Creator II

Hello,

Use this:

Load

Date,

if( isnull( Stage ), Peek('NewStage'), Stage ) as NewStage 

From ...

 

Regards