1 Reply Latest reply: Dec 4, 2013 1:35 PM by Srikanth P RSS

    SQL User Defined Function in a QVD Load

    Jeremy Schmitt

      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