topic Re: Get the next field value in QlikView

Get the next field value

Mon, 01 Oct 2012 12:32:40 GMT

Hi,

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?

Best regards, L. Sletten

Re: Get the next field value

Miguel_Angel_Baeyens — Mon, 01 Oct 2012 12:43:16 GMT

Hi,

You can use the Column() function, where Column(1) refers to the first expression column, Column(2) to the second, and so.

Hope that helps.

Miguel

Re: Get the next field value

Mon, 01 Oct 2012 12:51:57 GMT

Hi Lindasletten,

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.

Example:

field1	field2	Next-fieldValue
1	4	5
2	5	NULL

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.