Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
we have function Previous
I already try but it does not work : Previous (QUANTITY_HECTO) or precedes (QUANTITY_HECTO) and he says to me : mistake in the expression.
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);
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