topic Re: How to repeat the first value into next rows? in Water Cooler

How to repeat the first value into next rows?

Fri, 23 Aug 2013 01:39:05 GMT

Hi every body

I have one doubt in qlikview my data is like this

pol,item,prem

101,0,123

101,1,0

101,2,0

102,0,234

102,1,0

102,2,0

my O/P is

pol,item,prem

101,0,123

101,1,123

101,2,123

102,0,234

102,1,234

102,2,234

How can we develop the logic? One thing I want that logic as a Script Level as List Box, not for expression level?

Re: How to repeat the first value into next rows?

jeffmartins — Fri, 23 Aug 2013 01:53:44 GMT

Hi Nirmal Raj,

You should use the peek() funtion to get the previous record read and compare it with the current record.

See the attached file for more details. Hope this helps you.

Regards

Re: How to repeat the first value into next rows?

Fri, 23 Aug 2013 04:18:19 GMT

there are two ways

by wizard--

how to fill blank row?

go to ctrl E-->

then clik on table files

then clik on add table

then next

then clik on enable transformation steps

then clikon fill

clik fill

choose the target column

cell comdition

****************************************

Re: How to repeat the first value into next rows?

Alejandro_Hernández — Fri, 23 Aug 2013 04:30:22 GMT

see attached

Re: How to repeat the first value into next rows?

MayilVahanan — Fri, 23 Aug 2013 05:29:54 GMT

Try like this

Table:

LOAD pol,

item,

if(pol = peek('pol') and prem = 0,peek('prem'),prem) as prem;

LOAD * INLINE [

pol,item,prem

101,0,123

101,1,0

101,2,20

101,3,0

102,0,234

102,1,0

102,2,0

];