Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a sample data as given in below image (column A to D),
As a result I want Qty2 of previous row (Column E) of same order and where the Key not equals to "Key5".
Using Peek() function, I am able to get required results, Results are coming as shown below,
IF(peek(Order,-1)=Order and Key<>'Key5',peek(Qty2,-1),Qty1) | as Previous_QTy2 |
Please suggest is there any way to achieve said results.
Regards,
Girish.
Hi Girish;
you just needed to organize the table
order by Order,Qty1, Qty2 asc;
best regards.
Dear Claudio,
Thanks for looking into, I have checked the statement of "order by" but it is given the results as shown below,
The requirement is such that the sequence of data is important, so that order by will not work in our case.
Any other solution?
Hi Girish,
peek function requires that the table is sorted, you can ordering it again after creating the field previous_QTy2 using another standard to create the field Rowno.
Thanks again Claudio,
But I am failed to simulate your solution, can you please help me by checking & correcting the attached qvw.
Regards,
Girish.
Hi Girish
see if this way meets your needs.
Dear Claudio,
Thanks again,
But the results are not getting achieved.
Is there any other way???
Regards,
Girish.