I want to create a new column in my script where I use a value i the next row. My table is sorted the way I want it, so that's not an issue. I have created another column where I use a value on the previous row by using the Previous function. Is there a function in QlikView that allows me to compare a field value in the current row with a field value in the next row so that I can create my new column?
Actually you're looking for the next() function, right? Which functions exactly as the previous function, but instead returns the value of the next record... Correct?
If so, then the answer is that the next() function does not exist, but there is a way to work around it: sort your data descending (perhaps in a resident table) and use the previous function. This gives the same result.
When you load field 1 and 2 from the the table above sorted desc on field 1, the 'next-fieldValue' column can be calculated using the previous(field2) expression.