topic When I use a where statement in load script that looks like this: WHERE LineType = '1' AND isnull(OpenOrderQty,0) <> 0; I run in debug mode, I get the following error message: ErrorSource: Unknown source, ErrorMsg: Unknown description SQL SELECT * FROM S in QlikView

When I use a where statement in load script that looks like this: WHERE LineType = '1' AND isnull(OpenOrderQty,0) <> 0; I run in debug mode, I get the following error message: ErrorSource: Unknown source, ErrorMsg: Unknown description SQL SELECT * FROM S

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

When I use a where statement in load script that looks like this: WHERE LineType = '1' AND isnull(OpenOrderQty,0) <> 0; I run in debug mode, I get the following error message:

ErrorSource: Unknown source, ErrorMsg: Unknown description SQL SELECT * FROM SysproCompanyTurf.dbo.SorDetail WHERE LineType = '1' AND isnull(OpenOrderQty,0) <> 0.

I only want to load the data where Linetype=1 and where OpenOrderQty<> 0. And I'm a newbie to both Qlikview and SQL

OpenOrderQty is a "calulated" field in the LOAD statement before the WHERE clause

MShipQty + MBackOrderQty as OpenOrderQty,

I've tried OpenOrderQty <>0

I've tried OpenOrderQty <>'0'

Re: When I use a where statement in load script that looks like this: WHERE LineType = '1' AND isnull(OpenOrderQty,0) <> 0; I run in debug mode, I get the following error message: ErrorSource: Unknown source, ErrorMsg: Unknown description SQL SELECT * FR

chinnuchinni — Thu, 05 Apr 2018 10:58:17 GMT

try this:

(MShipQty + MBackOrderQty ) <> 0

Re: When I use a where statement in load script that looks like this: WHERE LineType = '1' AND isnull(OpenOrderQty,0) <> 0; I run in debug mode, I get the following error message: ErrorSource: Unknown source, ErrorMsg: Unknown description SQL SELECT * FR

sasiparupudi1 — Fri, 06 Apr 2018 14:30:31 GMT

You Can not use a calculated field in the where condition.

Try like this

SQL SELECT * FROM SysproCompanyTurf.dbo.SorDetail WHERE

LineType = '1' AND

(IsNull(MShipQty,0) +IsNUll(MBackOrderQty,0))<>0

Re: When I use a where statement in load script that looks like this: WHERE LineType = '1' AND isnull(OpenOrderQty,0) <> 0; I run in debug mode, I get the following error message: ErrorSource: Unknown source, ErrorMsg: Unknown description SQL SELECT * FR

Mark_Little — Fri, 06 Apr 2018 14:51:27 GMT

You can't use a where clause for a field that is being calculated in the load script.

You will need something like

Where (MShipQty <> 0 and MBackOrderQty <> 0) Or (LEN(TRIM(MShipQty)) <> 0 and LEN(TRIM(MBackOrderQty)) <> 0) AND LineType = 1.

I prefer to use Len and Trim over isnull incase of random spaces.

Mark