Set analysis : Valeur précédente

[Rivosoa]

Bonjour a tous, pouvez-vous m'aider sur qlik sense. dans un set, comment afficher la valeur précédente d'une ligne d'un tableau.

[Channa]

we have function Previous 

[Rivosoa]

I already try but it does not work : Previous (QUANTITY_HECTO) or precedes  (QUANTITY_HECTO) and he says to me : mistake in the expression.

[Channa]

in your xls load script

the bold one will have previous value

LOAD
jour,
ventes,
Previous(jour) as Prejour,
"valeur precedente"
FROM [lib://Test/Classeur1.xlsx]
(ooxml, embedded labels, table is Feuil1);

[Rivosoa]

Thanks for your help. I looked for a formul that could do it in the sheet itself and not in the script. because the values ​​are calculated from the sheet. I will do it in another way according to your proposal. thanks again

[Channa]

you are welcome bro