Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
I have a table as below and i would like to get the price of next date in every records but i don't want to use the inter-records function due to it may not work in some scenarios.
Would you please help? please refer to the attached QVW,thanks.
Source table:
ID | Txn_Date | Price |
1 | 1/1/2014 | 1000 |
1 | 1/2/2014 | 2000 |
1 | 1/3/2014 | 3000 |
2 | 1/1/2014 | 4000 |
2 | 1/2/2014 | 5000 |
2 | 1/3/2014 | 6000 |
3 | 1/1/2014 | 7000 |
3 | 1/2/2014 | 8000 |
I want to show:
ID | Txn_Date | Price | Price of Next Date |
1 | 1/1/2014 | 1000 | 2000 |
1 | 1/2/2014 | 2000 | 3000 |
1 | 1/3/2014 | 3000 | |
2 | 1/1/2014 | 4000 | 5000 |
2 | 1/2/2014 | 5000 | 6000 |
2 | 1/3/2014 | 6000 | |
3 | 1/1/2014 | 7000 | 8000 |
3 | 1/2/2014 | 8000 |
Hey Paul you can achieve your requirement from front end with inter record function,and if you make any selection your data remain same for the selection,for detail find the sample in attachment,hope this help you
Hi ,
Like this???
Thanks,
AS
See attached qvw.
Thanks, i want to do it in UI intead of the loading script
I don't want to use the inter-record functions due to it will not work if i filter the date or ID. thanks
If you want to do it in the front end then all you can use are the inter-record functions.... which you don't want to use. So you cannot do it.
Hey Paul you can achieve your requirement from front end with inter record function,and if you make any selection your data remain same for the selection,for detail find the sample in attachment,hope this help you
Hi Gupta, it's amazing! Thanks a lot for your help.