Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

MalcolmCICWF
Contributor II

SQL User Defined Function in a QVD Load

I have a user that added some SQL code to a qvd load that caused the below error.

Capture.JPG

He ran the code on SQL server fine, but apparently Qlikview does not like the same code when trying to load a Qvd. The code is running as below, is tehre a specific change that Qlikview needs to recognize these defined functions?

SQL SELECT

     SEQUENCE_NUM,

     DEBT_INFO_1,

     DEBT_INFO_2,

     DIRECT_MAIL_SCORE,

     TSYS_RATE,

  DBO.UDF_SCORE_RANK(SEQUENCE_NUM) AS SCORE_RANK,

  DBO.UDF_GROSS_RESPRATE(SEQUENCE_NUM) AS GROSS_RESPRATE,

  DBO.UDF_NET_RESPRATE(SEQUENCE_NUM) AS NET_RESPRATE,

  DBO.UDF_QUALIFY_RATE(SEQUENCE_NUM) AS QUALIFY_RATE

FROM BTOffer.dbo.VW_SOURCE_RECORD_ALL

1 Reply
Not applicable

Re: SQL User Defined Function in a QVD Load

Please check the QV user account access to user defined function in the schema ?

Community Browser