topic Re: Getting a query to load top rows in qlikview in QlikView

Getting a query to load top rows in qlikview

Fri, 18 May 2012 14:38:18 GMT

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?

Getting a query to load top rows in qlikview

swuehl — Fri, 18 May 2012 14:41:10 GMT

Have you tried the FIRST prefix? From the Help:

The first prefix to a Load or Select (SQL) statement is used for loading just a set maximum number of records from the data source, regardless of its length.

The syntax is:

first n( loadstatement | selectstatement )

where:

n is an arbitrary expressing which evaluates to an integer indicating the maximum number of records to be read.

Examples:

First 10 Load * from abc.csv;

First (1) Select * from Orders; (Note: The parenthesis is allowed but not required.)

Re: Getting a query to load top rows in qlikview

Tue, 23 Aug 2016 09:17:38 GMT

Thanks for the answer!