Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Question
you need to use functions peek() and previous() - look them up in the documentation, and look up some examples in this forum
Check out this WIKI page:
http://community.qlik.com/wikis/qlikview-wiki/using-peek-and-previous-functions-recursively-to-help-transform-data.aspx