topic Re: Trouble with Peek in QlikView

Trouble with Peek

martynlloyd — Thu, 21 Aug 2014 10:31:56 GMT

Can anyone spot the error here? I've been staring at it for ages....

I get NULL for _StartPref

//DATA

upType,upDate,upUser,upDocument,upParm

Start,21/08/2014 10:48:37,me,mydoc,Home

Start,21/08/2014 11:13:05,me,mydoc,Tuto

Skin,21/08/2014 11:13:05,me,mydoc,Blue

//SCRIPT

UPPref:
LOAD upType,
     upDate,
     upUser,
     upDocument,
     upParm
FROM
UserPref.qvs
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
Where upUser=OSUser() AND upType='Start'
;

Let _StartPref = Peek('upParm', -1, 'UPPref');

Re: Trouble with Peek

Gysbert_Wassenaar — Thu, 21 Aug 2014 10:46:35 GMT

OSUer() returns a username with the domain too: MYDOMAIN\MyUser. Your data only includes the user name, not the prefixed domain. The result is that no data is loaded. You can check this in the Table Viewer. Your table will be empty.

Re: Trouble with Peek

martynlloyd — Thu, 21 Aug 2014 10:58:47 GMT

Hi, that's only because I have removed the full AD name from the posting because of security rules. UPPref definately has rows.

Re: Trouble with Peek

Gysbert_Wassenaar — Thu, 21 Aug 2014 11:04:26 GMT

No idea then. I assume you've already checked that you're using the same case sensitive field names everywhere.

Re: Trouble with Peek

martynlloyd — Thu, 21 Aug 2014 11:11:08 GMT

Thanks, was a spelling error, i forgot a v.