Discussion Board for collaboration related to QlikView App Development.
My data looks as follows:
the value for the Note column is missing where
HL = L
Type = P
I want my data to look as follows:
It is basically copying the value of the Note field (COPP) from the row where
ID = 1 and HL = H and Type = P
to the row where
ID = 1 and HL = L and Type = P
and so on like other rows.
To achive this you can use previous() function. The key is to resident load the source table with specific order. For you it will be ID ASC, Note desc.
Load ID, if(previous(ID) =ID and Note ='', previoud(Note), Note) as Note, HL, Type resident SourceTable order by ID ASC, Note desc;
Drop SourceTable; rename table Tmp to SourceTablr;
View solution in original post