Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I need some help!

Hi,

I need some help!

Is it possible to make a script that creats a field with the value in the result column? I want to find out if we have done something with the same sort code for the client before.

If ClientNo and Sort code is the same on a older matter the answer should be No.

   

ClientNoMatterNoSort codeCreated dateResult
110000112015-01-01New
110001222015-02-01New
110002312015-03-01New
110003432015-03-15New
110000512015-04-04No
110000622015-04-15New

Regards

Magnus

1 Reply
marcus_sommer

You need for this a resident-load of your table with a sorting on ClientNo and SortCode and could the use peek() or previous() to check the current record-value with a previous one: Peek() vs Previous() – When to Use Each

- Marcus