2 Replies Latest reply: Aug 23, 2016 5:17 AM by Amit Kakkad RSS

    Getting a query to load top rows in qlikview

    brandon breitling

      Hi community,

       

      I have a query that I would like to use to load data into qlikview with.  It goes something like the following:

       

      select top 1 MessageData.value('(/LogObject//Message)[1]','nvarchar(50)') from dbo.ApplicationLog

      where AppCode = 'CodaReportingService'

      and MessageData.value('(/LogObject//Message)[1]','nvarchar(50)') like '%*Year:2012%Period:3*%';

       

      I've tried parts of it and can just load message data.  Do you know how I would get this query to work? 

       

      I might be able to do a simple work around.  I need to know how do I load just the top 10 or 1 rows of the select statement?