Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.
Thanks a lot!