Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
1adam_haj
Not applicable

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
jontydkpi
Not applicable

Re: Ignore row value/ move up column

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
3 Replies
jontydkpi
Not applicable

Re: Ignore row value/ move up column

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
Not applicable

Re: Ignore row value/ move up column

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
Not applicable

Re: Ignore row value/ move up column

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