Inter-record handle in straight table

[#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

[Anonymous]

What are the scenarios you suspect will not work with the inter-records function ?

[Looks like your qvw did not attach]

[mdmukramali]

Dear,

You can use

=Below(Price)  or Below(Sum(Price))

Thanks,

Mukram

[anbu1984]

Check this

[#5]

yes, it will not work if i filter ID or Date.

[#6]

The correct answer:

http://community.qlik.com/message/685171?et=watches.email.thread#685171