Need to fill empty row value with previous value in qliksense

[Rsaiq]

Hi All,

I have a sheet with some empty rows  in excel file just like below.

Expected output as below in qliksense

I need to fill missing values with previous value  if current row value is 0.

Could anyone please tell me how can i achieve this through qliksense script.

I have added raw data in a sheet and expected output in other sheet in a excel file.Kindly find attached excel file.

Thanks.

[Rsaiq]

Thanks @NitinK7 you are very helpfull.Its working fine and i can calculate the XIRR for 2 IDS.

Thanks for you support...🙂