Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
0 Replies