QlikView Inline tables with Null values

QlikView Inline tables with Null values

Sometimes you need a quick INLINE table for testing or just for a lookup table. In some of these cases you will need NULL values in your INLINE table. When you want to use NULL values in your INLINE table, you can use the following code:

//first set null interpreter to the string: NULL
SET NULLINTERPRET=NULL;

Orders:
LOAD * INLINE [
    OrderID, OrderDate
    112233, 1/2/2008
    223344, 2/2/2008
    334455, NULL
    445566, NULL
    556677, 3/3/2008
];

//reset null interpreter
SET NULLINTERPRET=;

Quite simple, but easy to forget.