Discussion Board for collaboration on QlikView Scripting.
Can anyone spot the error here? I've been staring at it for ages....
I get NULL for _StartPref
UPPref:LOAD upType, upDate, upUser, upDocument, upParmFROMUserPref.qvs(txt, codepage is 1252, embedded labels, delimiter is ',', msq)Where upUser=OSUser() AND upType='Start';
Let _StartPref = Peek('upParm', -1, 'UPPref');
Go to Solution.
No idea then. I assume you've already checked that you're using the same case sensitive field names everywhere.
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.
Hi, that's only because I have removed the full AD name from the posting because of security rules. UPPref definately has rows.
Thanks, was a spelling error, i forgot a v.