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: 
1adam_haj
Contributor III
Contributor III

Ignore row value/ move up column

i have a table like this

Time 1
Time 2
01/01/2017 14:32:5301/01/2017 17:32:53
01/01/2017 15:36:5301/01/2017 18:32:53
01/01/2017 16:48:5301/01/2017 19:32:53

i need to ignore or eliminite the first value in Time 2 ( red ) ant get the following value in the row instead of the first one. So the whole Time 2 should move up about one row.

how can i do that ?

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

If this is a front end expression, use Below()

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

If this is a front end expression, use Below()

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
techvarun
Specialist II
Specialist II

LOAD * INLINE [

    Time1, Time2

    01/01/2017 14:32:53, 01/01/2017 17:32:53

    01/01/2017 15:36:53, 01/01/2017 18:32:53

    01/01/2017 16:48:53, 01/01/2017 19:32:53

];

Data1:

Load Time1,Time2,Previous(Time2) as Time3

Resident Data Order by Time1 Desc;

DROP TABLE

Data;

Try above script

1adam_haj
Contributor III
Contributor III
Author

Thnaks, at the i added an ID with RecNo() +1 , but still thnaks Bellow made it too