topic Re: SQL FUNCTION IN SELECT in QlikView

SQL FUNCTION IN SELECT

Wed, 08 Oct 2014 17:29:21 GMT

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?

arsal_90 — Wed, 08 Oct 2014 17:42:53 GMT

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

Wed, 08 Oct 2014 17:44:39 GMT

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

anbu1984 — Wed, 08 Oct 2014 17:46:09 GMT

Sql keyword is missing.

ODBC CONNECT TO ....

Load *;

Sql SELECT

dbo.fn_adjusted_date( table.column1)

FROM [ARSystem].[dbo].

(NOLOCK)

order by column1;

maxgro — Wed, 08 Oct 2014 18:32:42 GMT

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 — Wed, 08 Oct 2014 19:09:02 GMT

Anbu is right SQL keyword is missing

Anonymous — Wed, 08 Oct 2014 19:23:18 GMT

load

;

SELECT

column_name

FROM [nameDB.[dbo].[name_table]

order by colum_name;

Wed, 08 Oct 2014 20:09:18 GMT

I added SQL but did not work either!