Previous - script function

Previous() finds the value of the expr expression using data from the previous input record. In the first record of an internal table, the function will return NULL.

Syntax:  

Previous(expr)

Return data type: dual

Arguments:  

Argument Description
expr The expression or field containing the data to be measured.

The expression can contain nested previous() functions in order to access records further back. Data are fetched directly from the input source, making it possible to refer also to fields that have not been loaded into QlikView, that is,even if they have not been stored in its associative database.

Limitations:  

In the first record of an internal table, the function returns NULL.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?