Using SQL in QlikView

Andrew_Maynard1 — Fri, 03 Feb 2023 16:09:44 GMT

How can I just pull the first line from a table ?

I tried "SELECT TOP 1 * FROM [TableName]" ... didn't seem to like the 1.

Even better, How would I just pull the column list ?

Even better than that, where is a user manual for SQL commands that work in QlikView

Re: Using SQL in QlikView

BrunPierre — Fri, 03 Feb 2023 19:14:56 GMT

Use the First prefix in a preceding load.

[TableName]:

First 1

LOAD *;

SQL SELECT * FROM [TableName];