Recursive expression

Wed, 22 Oct 2014 14:34:57 GMT

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

topic Recursive expression in QlikView

Recursive expression