PEEK not working on inline loaded table

Fri, 09 Apr 2010 13:54:41 GMT

Hi,

In the example below, the variable vSPOTReloadDate remains empty after the PEEK statement. When I try the PEEK function with a 'normally' loaded table, it works just fine. The SPOTProperties table get loaded fine.

I can't find this limitation in the docs. Is this by design or am I missing something here ?

Any help would be greatly appreciated.

Jan

SPOTProperties:

LOAD * INLINE
[PropertyID, PropertyName, PropertyValue
0, SPOTProp1, 23
1, SPOTProp2, 67];

LET vSPOTReloadDate = Peek('PropertyValue', 0, 'SPOTProperties');

PEEK not working on inline loaded table

vupen — Mon, 12 Apr 2010 08:31:14 GMT

Small correction is needed in the Peek syntax. The table name should not be in quotes. Correct code in your example will be:


Let VSPOTReloadDate = Peek('PropertyValue',0,SPOTProperties);

topic PEEK not working on inline loaded table in QlikView

PEEK not working on inline loaded table

PEEK not working on inline loaded table