Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Recursive expression

Hello,

I search to calculate a recursive expression in straight table. It is a measure that depends on the value that comes directly before it:

  Solde(0)= [valeur Stock Initial] +[Valeur Arrivée regroupement] - [ traitée Jour ]  If Flag_First_Day=1

  Solde(i)=Solde (i-1) +[Valeur Arrivée regroupement] - [traitée Jour] else

I calculated the measures used in my recursive expression in script, so i have  [valeur Stock Initial] and [Valeur Arrivée regroupement] and [ traitée Jour ], each field is in different table

I attached the data model

Itried to use the function above() but I couldn't have the right result!

Help me plz to find solution to my problem

Thank you

0 Replies