Get a column with the difference between two rows - Above() not working

Paulo_IntelFab — Wed, 19 Mar 2025 21:58:43 GMT

Hi, I need to get a column with the diffence between a row and the previous row. I`m using Qlik Cloud and the load script is quite simple.

[Teste_NPTs]:
LOAD
[OrderingField],
[SubtractField],
[Flag]
FROM [lib://A - Rascunho:DataFiles/Teste_NPTs.qvd]
(qvd);

The rows look like this:

I tried to use the function Above, but an error is thrown and I cannot solve it.

[Teste_NPTs]:
LOAD
[CampoOrdenar],
[CampoSubtrair],
[Flag],
[CampoSubtrair] - Above([CampoSubtrair]) As difference

FROM [lib://A - Rascunho:DataFiles/Teste_NPTs.qvd]
(qvd);

The error message is:
Unexpected token: '(', expected one of: ',', ':', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', 'OPERATOR_STRING_CONCAT', ...

[Teste_NPTs]: LOAD [CampoOrdenar], [CampoSubtrair], [Flag], [CampoSubtrair] - Above>>>>>>(<<<<<<[CampoSubtrair]) As difference FROM [lib://A - Rascunho:DataFiles/Teste_NPTs.qvd] (qvd)

I'm glad for any help!

Re: Get a column with the difference between two rows - Above() not working

marksouzacosta — Wed, 12 Jun 2024 20:13:55 GMT

Hi @Paulo_IntelFab

Above is a chart function, it does not work in the Load Script.
Look for Previous (Previous - script function | Qlik Sense on Windows Help) or Peek (Peek - script function | Qlik Sense on Windows Help) functions.

Re: Get a column with the difference between two rows - Above() not working

Paulo_IntelFab — Wed, 12 Jun 2024 20:27:03 GMT

Thanks a lot!

topic Re: Get a column with the difference between two rows - Above() not working in Data Movement & Streaming

Get a column with the difference between two rows - Above() not working

Re: Get a column with the difference between two rows - Above() not working

Re: Get a column with the difference between two rows - Above() not working