7 Replies Latest reply: Jun 4, 2014 1:06 AM by pradeep t RSS

    how to find top 1

      how to find top first  value in the column through scripting.

      I have a sql query i need to implement this query through script in qlikview.

      i had already loaded these fields from excel.

       

      SELECT TOP 1 [new value] FROM status_history

       

      WHERE [defect id] = new.[defect id].