Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Filtering/Comparing Null/Blank String Fields

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:

error loading image

... 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!!!











2 Replies
Highlighted
Not applicable

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

Highlighted
Not applicable

Noted Rainer, I have totally overseem this...

Thanx again!!!