Create Column with previous sales value for same dimension
Hi Guys, I am new to Qlik sense and I need a help to solve this issue:
I need to retrieve previous data from same dimension ,
For example, for order "1" I need to check what was the previous sales date for product A before 03/06/2020 (dd/mm/yy format) and bring the value for that order, in this example it was order 7 that occurred in 14/01 with a R$43 value. I need this previous value for each line.