topic Re: Scripting issue - QV not reading script correctly!?! in QlikView

Scripting issue - QV not reading script correctly!?!

Mon, 16 Sep 2013 18:09:09 GMT

LOAD SalesType_Code,
    Sales_Description,
    SalesType,
    GL_Acct;
SQL SELECT *
FROM "FPA_Admin".dbo.SALESTYPE_CODES
WHERE SalesType_Code = "501" or SalesType_Code = "503" or SalesType_Code = "505";

LOAD Svc_Plan As "PMA_ServicePlan",
    Common_Service_Plan,
    Service_Plan,
    Summary AS "Summary_ServicePlan";
SQL SELECT *
FROM "FPA_Admin".dbo.SERVICE_PLAN_CODES;

error message:

Field not found - <SalesType_Code>

SQL SELECT *

FROM "FPA_Admin".dbo.SERVICE_PLAN_CODES

Issue: The error appears to suggest that script is not being read by QV correctly,

due to the field not matching the table in the SQL SELECT table.

any suggestions????

Re: Scripting issue - QV not reading script correctly!?!

MayilVahanan — Mon, 16 Sep 2013 18:13:13 GMT

Do u have field SalesType_Code in your database.

If so,

Try like this

LOAD SalesType_Code,

Sales_Description,

SalesType,

GL_Acct,

SalesType_Code where match(SalesType_Code ,501,503,505);

SQL SELECT *

FROM "FPA_Admin".dbo.SALESTYPE_CODES;

Re: Scripting issue - QV not reading script correctly!?!

Mon, 16 Sep 2013 18:30:15 GMT

Didn't work, same error

What works:

LOAD SalesType_Code,

Sales_Description,

SalesType,

GL_Acct;

SQL SELECT *

FROM "FPA_Admin".dbo.SALESTYPE_CODES;

What doesn't work wit the SQL WHERE CLAUSE.

LOAD SalesType_Code,

Sales_Description,

SalesType,

GL_Acct;

SQL SELECT *

FROM "FPA_Admin".dbo.SALESTYPE_CODES

WHERE SalesType_Code = "501" or SalesType_Code = "503" or SalesType_Code = "505";

Question is "What is the syntax for a correct WHERE CLAUSE? with OR operator and text fields?

thanks. .

T L

Re: Scripting issue - QV not reading script correctly!?!

MayilVahanan — Mon, 16 Sep 2013 18:33:13 GMT

In sql, we give single quotes

WHERE SalesType_Code = '501' or SalesType_Code = '503' or SalesType_Code = '505';

Re: Scripting issue - QV not reading script correctly!?!

Mon, 16 Sep 2013 18:36:59 GMT

Thank you!

Note to self: "I am an idiot!"

Re: Scripting issue - QV not reading script correctly!?!

MayilVahanan — Mon, 16 Sep 2013 18:48:24 GMT

Hi sportsgirl

Everyone do small mistake..