topic Re: Inter-record handle in QlikView

Inter-record handle

Tue, 23 Dec 2014 11:52:26 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

amit_saini — Tue, 23 Dec 2014 12:00:20 GMT

Hi ,

Like this???

Thanks,
AS

Re: Inter-record handle

Gysbert_Wassenaar — Tue, 23 Dec 2014 12:00:47 GMT

See attached qvw.

Re: Inter-record handle

Tue, 23 Dec 2014 12:13:02 GMT

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

Re: Inter-record handle

Tue, 23 Dec 2014 12:14:08 GMT

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

Re: Inter-record handle

Gysbert_Wassenaar — Tue, 23 Dec 2014 12:16:21 GMT

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.

Re: Inter-record handle

Tue, 23 Dec 2014 12:54:16 GMT

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

Re: Inter-record handle

Wed, 24 Dec 2014 01:32:40 GMT

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