How to get cell from table

[#1]

Hello there, I got a pivot table object. In one column i got some integer data displayed as Expression. The rows are like this:

Header 1
1600
0
0
0
2323
0
0

I need to replace first 3 zeros with 1600 and last two with 2323. The numbers are generated by formula with some data from Data base like this:

=sum({<[Вид запис]={6}>} if([Продуктова група]='TRF-N' or [Продуктова група]='TRF-R' or [Продуктова група]='SWH-PF' or [Продуктова група]='FS-PF' or [Продуктова група]='KL-PF' or [Продуктова група]='ELB-M' or [Продуктова група]='ELB-MAN' or [Продуктова група]='ELB-SPEA' or [Продуктова група]='ELB-PLAST' or [Продуктова група]='IGN-PF',0,[Количество по допълнителна мярка])).

In excel that is easly done but is that posible in qlikview?

[israrkhan · Accepted solution]

you can use Previous() function in load script, like

if (sum(Amount) = 0, Previous(sum(Amount)), Sum(Amount))

or in the front end, use Before() or above() function.......

[#3]

Above(.....(column number or name))  Thanks alot. For the current scenario  if(.....=0,Above([Header 1]), .........)