Showing in two columns values from a cell of previous two rows

[felipeyague]

Hello, I would like to have a table where i can show in a row the values of the production costs of previous orders. I mean, my dimension is my produced material, and the cost of the current production order i can show in the row where the data of that production order are shown. But in the same row i would like to show the values of the two previous orders of that material in order to know the difference with the current order. In a graph it would be easier i think but i would like to have in a table. To sum up, it would be how to show values from previous records in a table in the current records. It would be great to do it in the data load editor. Thanks. 

[brunobertels]

Hi 

try the above function 

assuming your mesure is sum(cost) so the expression should be 

above(sum(cost),0,2)

[MayilVahanan]

Hi @felipeyague 

In Data load editor, try with Peek(fieldName,-2) to get the previous 2 order. 

Ref for Peek:

https://help.qlik.com/en-US/sense/November2020/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecor...

[felipeyague]

and will i be able to filter by measure? I mean, I need to get the cost of the previous orders where the material produced is the same than the one in the current order. Thanks.

[felipeyague]

Thanks. I will try. But, how to select in the previous orders just the ones which produced the same material that the one in the current order? Thanks.