Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Showing results for 
Search instead for 
Did you mean: 

Merging rows - previous / peek ?

I've got some data that I've cleansed but at the point where I need to merge two rows or in Excel terms move some values up a row.

i.e. For those 5 fields where TRANS_REF_LINE is 001 they want to be merge with the above row.

move data up a line.PNG

If it helps the TRANS_REF_DOC field is unique. What's the easiest way of doing that? I've got an inkling that it may be using Previous or Peek but unsure of the best way.

1 Reply

Hello Shane:

Did you ever figure out how to do this?  I have a very similar need.  Thanks in advance.