3 Replies Latest reply: Mar 29, 2011 1:23 PM by tommyhot RSS

    Need help with qlikview syntax to converting SQL nested select

       

      Hi,

      Can someone help me convert this sql statement to qlikview script? I have these 2 records in qvd but not able to find the appropriate qlikview syntax to retrieve the record with smaller SQ#. Example below.

      SELECT * FROM TableABC WHERE ClientID = 51710 AND SQ#=(select MIN(SQ#) from TableABC where ClientID=51710)

       

      TableABC

      ClientID SQ# TeamID Date

      51710 2 4 20-JAN-11

      51710 3 12 20-JAN-11