topic Re: How to Subtract Date from the previous row???? in App Development

How to Subtract Date from the previous row????

gauravgg — Tue, 15 Nov 2016 12:26:22 GMT

I have the following table

I have to create a New Column

I have to subtract RowNo 2 from RowNo 1 for which the result should come in new column in format (HH:MM:SS)

This should be applied for all the rows.

sunny_talwar — Tue, 15 Nov 2016 12:33:43 GMT

In the front end of the app, you can use Above or Below function:

Timestamp - Above(Timestamp)

gauravgg — Tue, 15 Nov 2016 12:50:41 GMT

Hi Sunny

If i an not wrong Timestamp - Above(Timestamp) can be done on the visualisation part

Can this be done in the script ?

sunny_talwar — Tue, 15 Nov 2016 12:52:34 GMT

You can use Peek/Previous in the script to do this. But make sure your data is correctly sorted when you use peek/previous.

gauravgg — Tue, 15 Nov 2016 12:56:38 GMT

it would be help full , if you share script

or Share .qvf

sunny_talwar — Tue, 15 Nov 2016 13:03:17 GMT

Something like this:

SET TimestampFormat='MM-DD-YYYY hh:mm';

Table:

LOAD Timestamp,

RowNo

FROM

[https://community.qlik.com/thread/239834]

(html, codepage is 1252, embedded labels, table is @1);

FinalTable:

LOAD RowNo,

Timestamp,

Interval(Timestamp - Previous(Timestamp), 'hh:mm:ss') as NewColumn

Resident Table

Order By RowNo;

DROP Table Table;