topic Problem setting variable to value of field in QlikView

Problem setting variable to value of field

bismart — Thu, 10 Nov 2011 10:32:54 GMT

I want to set a variable to the value of a field and exit script if condition is not met.

Problem I notice when running in debug is that vBuild variable ends up as a NULL value

Anybody see where I'm going wrong?

Thanks

Dave

// Sample

SET vBuild = RunNBF;

ValidityCheck:
LOAD
RunNBF
FROM
$(vMap)QVD DataLoader\QWIN_RunStatus.qvd
(qvd);

LET vBuild = RunNBF;

// Exit if Not right to rebuild
IF $(vBuild) <> '0' then
EXIT Script;
ENDIF

Thu, 10 Nov 2011 12:50:06 GMT

Hello Bismart,

you should use the peek()-command to get the according value, similar to this:

LET vBuild = Peek('RunNBF'); // don't forget the single quotes

TRACE --> $(vBuild) ;

Note: The TRACE-Command shows you the value in script execution output window.

HtH

Roland

bismart — Sat, 12 Nov 2011 13:56:07 GMT

Thanks Roland

mental block... Peek works a treat