Load*,If((QTY)=0,Peek('Test'),QTY) As Test
I have used this condition to get the previous data when the value is null but if i use any filter it is showing the same value and its not showing as per the filter
If you want your previous data to be displayed based on your selection than you have to handle this in frontend script not in backend. For example, you can use "Above()" function in straight table to achieve this.
If(Above(QTY)=0, Above(QTY,2), Above(QTY))