script

Ever since leaving PHP coding for QlikView - I've always missed the Handy isset function to check if a variable, well, isset. But its actually possible to use the isnull function to do the same in the script. Just remember not to use $ sign expansion! Since this will evaluate the variable, before its passed into the function.

This works nicely:

If isnull(foo) Then
    Let foo = 'bar';
    trace now it exists;
Else
    trace exists;    
End if

I’m working on the QlikView combo certification and have noticed this minor bug in the LOAD * RESIDENT syntax.

AcctInvoiceReceiptstxBillingTreat:  
LOAD KEY_MEDNO,Treat.TX,KEY_INVOICE,
KEY_ACCTNUM,Treat.MNAME RESIDENT tab1 ;

If I do the above, a table with the label AcctInvoiceReceiptstxBillingTreat is created.

If I however do a * load then

AcctInvoiceReceiptstxBillingTreat:  
LOAD 
* RESIDENT tab1 ;

The table created is labelled tab1.