Is there a way to do this in Qlik too, either being done all in the one file or via a multiple number of files but having those automated (perhaps with some VB script)?
Keen to see if anyone has tackled/solved how to do this?
With interrecord-functions like above() could you access within a chart other rows and columns and for handling more than one return-value you need a range-function. Maybe something like this might work for you: