Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
HI
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
];
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
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
ok
ok
****************************************
see attached
HI
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
];