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: 
julruiz123
Partner - Creator
Partner - Creator

Calculate difference with the previous record in a straight table

Hi,

I have the next table

img.png

and i need show in the last column the difference with the previous record.

Any help?

Thanks!

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hi,

Use the following inter-record function Above() as the expression:

[Facturación] - Above([Facturación])

Hope that helps,

Miguel

View solution in original post

2 Replies
Miguel_Angel_Baeyens

Hi,

Use the following inter-record function Above() as the expression:

[Facturación] - Above([Facturación])

Hope that helps,

Miguel

julruiz123
Partner - Creator
Partner - Creator
Author

Thanks Miguel,

It works perfectly