Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SQL FUNCTION IN SELECT

I am trying to use a SQL prebuilt function in my SELECT statement  but it errors out saying " not found". Do you know why this would be happening.

Script I am using is

load *;

SELECT

dbo.fn_adjusted_date( table.column1)

FROM [ARSystem].[dbo].

(NOLOCK)

order by column1;

Am I missing any syntax?

7 Replies
arsal_90
Creator III
Creator III

Order by Column 1 is the mistake what i think qlikview didn't read column 1 please pass column name instead of column 1

Not applicable
Author

I have used the column_name ... not column 1... Sorry to confuse you!

anbu1984
Master III
Master III

Sql keyword is missing.

ODBC CONNECT TO ....

Load *;

Sql SELECT

dbo.fn_adjusted_date( table.column1)

FROM [ARSystem].[dbo].

(NOLOCK)

order by column1;

maxgro
MVP
MVP

you can check the syntax of the sql select with your db tool

if the db is sql server, sql server management studio

then, when you have a checked statement, copy it in qlikview and add load *;

arsal_90
Creator III
Creator III

Anbu is right SQL keyword is missing

maverjannet
Specialist
Specialist

load

*

;

SELECT

column_name

FROM [nameDB.[dbo].[name_table]

order by colum_name;

Not applicable
Author

I added SQL but did not work either!