Discussion Board for collaboration on QlikView Scripting.
I need to be able to create a Field that flags either yes or no based on a particular set of criteria. Please see mock table below.
I am trying to create the field highlighted with the red writing.
I need to distinguish when the last RefSeq of a particular RefNoType is either Closed or ReClosed when this is true to show 'Yes'
if it is notified or Reopened or if the there is another RefSeQ after it was CLosed or Reclosed then it should show 'No'
I would appreciate any help.
Thanks in advance