Discussion Board for collaboration related to QlikView App Development.
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:
[..\..\Datos Externos\CSAV_BRASIL\dicionario mercado-csav\dicionario.xls] (biff, embedded labels, table is Sheet1$
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).
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.
Sum(TEUS) as SumTeus
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.
Noted Rainer, I have totally overseem this...