# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Certification Exam Sale - 40% off. Register by June 30, 2020. GET DETAILS
New Contributor III

## Expression based on previous row

Hello everyone,

i have this example

DATE                ID      ID2  STATUS

01/01/2016      001    021      D1

13/02/2017      001    022      D1

13/04/2017      001    023      D2

i have made the aggregate by ID and DATE to show the ID by the max(Date) but i want to know if its possible  using only the expression(not script option), get the difference in months between records of the same ID (using DATE).

In simple way, get the difference on months between rows with same ID.

Regards.

1 Solution

Accepted Solutions
Highlighted
Honored Contributor III

## Re: Expression based on previous row

Hi Paula,

may be this

Alt((Year(DATE)-Above(TOTAL Year(DATE))-1)*12+Month(DATE)+(12-Above(TOTAL Month(DATE))),'Null')

Regards,

Antonio

4 Replies
Highlighted

## Re: Expression based on previous row

Hi,

check above().

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
New Contributor III

## Re: Expression based on previous row

Hi Prashant,

Above _Function doesn't run well.

i need :

DATE                ID      ID2  STATUS     DIFFERENCE(IN MONTHS)

01/01/2016      001    021      D1          NULL

13/02/2017      001    022      D1          13

13/04/2017      001    023      D2            2

to calculate the difference between rows from DATE field, to records with the same ID.

I hope that helps...

Thanks a lot!

Highlighted
Honored Contributor III

## Re: Expression based on previous row

Hi Paula,

may be this

Alt((Year(DATE)-Above(TOTAL Year(DATE))-1)*12+Month(DATE)+(12-Above(TOTAL Month(DATE))),'Null')

Regards,

Antonio

Highlighted
New Contributor III

## Re: Expression based on previous row

Thank you Antonio!

It runs very well