1) covernote Number and Issue Date are coming in-line with Each Other & In Mentioned Sequence.
2) Data Arrives in Ascending Order of Issue_Date
Pseudo-Code
1) Split Issue_Date Column. Capture Month & Date into two Difference Array Variables/Dataset (as Preferred)
date_array1[]= issue_date.split(1)
month_array2[]=issue_date.split(2)
2) Store CovenantNo into another array
covenant_no_array3[]= loop(Covenant Number)
3) Apply Bubble Sort (Quick Sort Can also be done for Faster Results, but Bubble Sort will be easy to identify out of Order Value.)-
a. First on month_array2[] (use as outer loop)
b. Second on date_array1[] (use as inner loop)
4) When out of Order Value found, print that value as Current Value. Pre-Value is index-1 of Current Value. Post Value is index+1 of current value. Covenant number is index of current value,
Pseudo-code isn't really helpful. Qlikview works (very well) with fields and tables and not with arrays although fields and tables could be considered as arrays in some way. I think you should provide a small example with a few inline-datas and a better description what do you want to do.
