How to get cell from table

Wed, 27 Aug 2014 13:17:34 GMT

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?

Re: How to get cell from table

israrkhan — Wed, 27 Aug 2014 13:33:54 GMT

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.......

Re: How to get cell from table

Thu, 28 Aug 2014 08:24:38 GMT

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

topic How to get cell from table in QlikView

How to get cell from table

Re: How to get cell from table

Re: How to get cell from table