I have a user that added some SQL code to a qvd load that caused the below error.
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