4 Replies Latest reply: Dec 1, 2011 9:17 AM by Marc Livingston RSS

    Return first record per part only.

      I have a Part table. Our system allows you to attach a drawing to a part record, and this is stores in another table. You are able to attach more than one drawing to each part, hence creating a one to many link.

       

      How can I tell qlikview to only return the first record per part? IE if one part has 2 drawings I only want to have the first found drawing to be returned.

       

       

      Edit: Would doing something like this work? I would apply the same formula to all fields so if the previous record is the same part (IE this is the second attachment) it would return null values?

       

      if(peek(partnum)=partnum,null(),partnum) as part