topic Re: Inter-record handle in straight table in QlikView

Inter-record handle in straight table

Tue, 23 Dec 2014 11:47:04 GMT

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

Re: Inter-record handle in straight table

Anonymous — Tue, 23 Dec 2014 11:52:00 GMT

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

[Looks like your qvw did not attach]

Re: Inter-record handle in straight table

mdmukramali — Tue, 23 Dec 2014 12:00:23 GMT

Dear,

You can use

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

Thanks,

Mukram

Re: Inter-record handle in straight table

anbu1984 — Tue, 23 Dec 2014 12:13:34 GMT

Check this

Re: Inter-record handle in straight table

Tue, 23 Dec 2014 12:16:55 GMT

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

Re: Inter-record handle in straight table

Wed, 24 Dec 2014 01:34:08 GMT

The correct answer:

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