topic Filtering/Comparing Null/Blank String Fields in QlikView

Filtering/Comparing Null/Blank String Fields

Wed, 05 Jan 2011 13:21:54 GMT

Greetings gentlemen and ma'ams!!!

I am trying to bring only fields that are not blank or null during a LOAD / LEFT JOIN statement, but unsuccesfully.

The code follows below:

LOAD

Customer_Shipper

SUM

(Teus) AS

SUMTEUS

FROM

[..\..\Qvd\CSAV_BRASIL\MercadoECSA.qvd](qvd)

;

LEFT

JOIN

LOAD

Shipper

AS Costumer_Shipper

[Partner Code]

FROM

[..\..\Datos Externos\CSAV_BRASIL\dicionario mercado-csav\dicionario.xls] (biff, embedded labels, table is Sheet1$

)

WHERE

NOT EXISTS(Costumer_Shipper,''

)

GROUP

BY Customer_Shipper,

[Partner Code];

and the following errors are dysplayed after running the script:

... as far as I can see, my code doesn't seem to be out of logic, and I just can't figure out what's wrong...

Could someone shed some light upon this, PLEASE???

In advance, my apologies if this is an seely question (official noob here).

Thx!!!

Filtering/Comparing Null/Blank String Fields

Wed, 05 Jan 2011 13:31:30 GMT

Hi,

you are using a SUM function and an additinal field CUSTOMER_SHIPPER or so.

That´s the reason you need a GROUP BY statement so that SUM can work correctly.

Load

Customer_Shipper

Sum(TEUS) as SumTeus

From *****

Group By Customer_Shipper;

But you are loading your data from a QVD file. Not sure at the moment if it works in this case.

Maybe you have to load the table again by a resident statement.

Good luck!

Rainer

Filtering/Comparing Null/Blank String Fields

Wed, 05 Jan 2011 17:42:34 GMT

Noted Rainer, I have totally overseem this...

Thanx again!!!