Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Inter-record handle

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:

IDTxn_DatePrice
11/1/20141000
11/2/20142000
11/3/20143000
21/1/20144000
21/2/20145000
21/3/20146000
31/1/20147000
31/2/20148000

I want to show:

IDTxn_DatePricePrice of Next Date
11/1/201410002000
11/2/201420003000
11/3/20143000
21/1/201440005000
21/2/201450006000
21/3/20146000
31/1/201470008000
31/2/20148000
Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Inter-record handle

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

View solution in original post

7 Replies
amit_saini
Honored Contributor III

Re: Inter-record handle

Hi ,

Like this???

Thanks,
AS

MVP & Luminary
MVP & Luminary

Re: Inter-record handle

See attached qvw.


talk is cheap, supply exceeds demand
Not applicable

Re: Inter-record handle

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

Not applicable

Re: Inter-record handle

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

MVP & Luminary
MVP & Luminary

Re: Inter-record handle

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.


talk is cheap, supply exceeds demand
Not applicable

Re: Inter-record handle

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

View solution in original post

Not applicable

Re: Inter-record handle

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