Inter-record handle

[#1]

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

[amit_saini]

Hi ,

Like this???

Thanks,
AS

[Gysbert_Wassenaar]

See attached qvw.

[#4]

Thanks, i want to do it in UI intead of the loading script

[#5]

I don't want to use the inter-record functions due to it will not work if i filter the date or ID. thanks

[Gysbert_Wassenaar]

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.

[#7 · Accepted solution]

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

[#8]

Hi Gupta,  it's amazing! Thanks a lot for your help.