how to populate the field values according previous field value

[QlikAddictFr]

Hello Everyone,

I need your help.

I want populate null value with previous value based on Employe and last Date, i tried script below but it work only in next null value in one field but not all fields.

i want this table below please

Thank you for your help

[Kushal_Chawda]

@QlikAddictFr  try below condition,

=if( isnull(Tmp_ContractRessource_TypeContractRessource),

peek('Tmp2_ContractRessource_TypeContractRessource'),

Tmp_ContractRessource_TypeContractRessource) as Tmp2_ContractRessource_TypeContractRessource