topic Re: date difference by rows for a single column in QlikView

date difference by rows for a single column

Mayuri1 — Thu, 28 Feb 2019 23:01:34 GMT

Hi,

How can I generate a column to display the difference between two rows?

date

1/17/2019

1/20/2019

1/21/2019

1/22/2019

1/23/2019

1/24/2019

1/25/2019

jonathandienst — Fri, 01 Mar 2019 05:23:18 GMT

Assuming date is a numeric date field:

LOAD date, 
    if(RowNo() <> 1, date - previous(date)) as diff
....

MindaugasBacius — Fri, 01 Mar 2019 05:28:38 GMT

I guess firstly you need to make an Order by Invoice number (some other metric) and by date itself. Than you can move on to Jontydkpi suggestion.