Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Contributor III

Re: SQL FUNCTION IN SELECT

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

Re: SQL FUNCTION IN SELECT

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

anbu1984
Honored Contributor III

Re: SQL FUNCTION IN SELECT

Sql keyword is missing.

ODBC CONNECT TO ....

Load *;

Sql SELECT

dbo.fn_adjusted_date( table.column1)

FROM [ARSystem].[dbo].

(NOLOCK)

order by column1;

MVP
MVP

Re: SQL FUNCTION IN SELECT

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
Contributor III

Re: SQL FUNCTION IN SELECT

Anbu is right SQL keyword is missing

maverjannet
Valued Contributor

Re: SQL FUNCTION IN SELECT

load

*

;

SELECT

column_name

FROM [nameDB.[dbo].[name_table]

order by colum_name;

Not applicable

Re: SQL FUNCTION IN SELECT

I added SQL but did not work either!