topic PEEK does not work on inline table ? in QlikView

PEEK does not work on inline table ?

Fri, 09 Apr 2010 13:37:15 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

LET vSPOTDate = MakeDate(2010,4,9);
LET vSPOTTime = MakeTime(12,23,56);

SPOTProperties:
LOAD * INLINE
[PropertyID, PropertyName, PropertyValue
0,SPOTReloadDate,$(vSPOTDate)
1,SPOTReloadTime,$(vSPOTTime)];

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

PEEK does not work on inline table ?

sparur — Fri, 09 Apr 2010 13:56:27 GMT

Hello Jan.

try that code:

LET vSPOTDate = MakeDate(2010,4,9);
LET vSPOTTime = MakeTime(12,23,56);

SPOTProperties:
LOAD

IF( PropertyID = 0, $(vSPOTDate), $(vSPOTTime)) AS PropertyValue

INLINE
[PropertyID, PropertyName
0,SPOTReloadDate
1,SPOTReloadTime];

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

PEEK does not work on inline table ?

sparur — Fri, 09 Apr 2010 13:58:54 GMT

I create a small example.

PEEK does not work on inline table ?

Fri, 09 Apr 2010 14:10:53 GMT

Hi Anatoly,

thanks for your quick answer!

Your solution works fine indeed, I just don't understand why ? For Qlikview, what is the difference between our solution (internally I mean)

Jan

PEEK does not work on inline table ?

sparur — Fri, 09 Apr 2010 14:19:14 GMT

I think that in INLINE table Qlikview can't evaluate a variable.

PEEK does not work on inline table ?

Fri, 09 Apr 2010 14:22:25 GMT

I think it can, because if you open the table viewer and do a 'preview' the data is loaded into the table correctly.

I copied my code into a new empty project and there it works fine. It must be something else in my project messing things up.

Thanks for your help!

Jan

PEEK does not work on inline table ?

Fri, 09 Apr 2010 14:40:20 GMT

I have the solution :

a QUALIFY statement occured before the code sample I posted. So the correct syntax is :

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

So even though the PEEK function takes a 'tablename' as parameter, the fieldname needed to be fully qualified.

PEEK does not work on inline table ?

sparur — Fri, 09 Apr 2010 17:51:30 GMT

Yes, you are right. Inline can evaluate variable. But I didn't understand why you use an QUALIFY statement?