topic Garbage after statement in QlikView

Garbage after statement

francisvandergr — Sat, 04 Jun 2011 08:11:32 GMT

OpenstaandOrders:

load

Factuurnummer,

Crediteur,

Cred\Openstaand,

Ordernummer,

Factuurdatum,

BedragVV,

Koers,

teller,

artcode,

Valcode,

Ontvangenbedrag as Bedrag,

Cred

Resident Crediteuren_tmp where Ontvangenbedrag is null;

When i have this script i get a message: garbage after statement. I want to have al records from the table Crediteuren_tmp where the field Ontvangenbedrag is empty

Garbage after statement

Sat, 04 Jun 2011 09:40:15 GMT

Hi,

change "where Ontvangenbedrag is null;" with "where IsNull(Ontvangenbedrag);"

Hope this helpes!

Stefan

Garbage after statement

francisvandergr — Sat, 04 Jun 2011 09:43:17 GMT

Thanx it works.

Francis