topic Variable in Load Script in QlikView

Variable in Load Script

Anonymous — Mon, 09 Mar 2015 12:55:03 GMT

in my Load Script;

UserAll:

LOAD distinct User

FROM

[..\Qlik\Audit_MM-QV01.log]

(txt, utf8, embedded labels, delimiter is '\t', msq);

let vUsers= NoOfRows('UserAll');

FOR i = 0 to $(vUsers)

SET vLogUsers$(i)=' ';

on my front end i created a variable vLogonUsers :- concat(User,',') this list All the users separated by a comma

now on the second part i want to create variables vLogUsers$(i)

itried

SET vLogUsers$(i)=' peek(User,$(i),UserAll'); not working

please if there could be a way to do this in the load script

in front end i can manually have vLogUser1 :- subfield(vLogonUsers,','1) as so on

but i want o do it in the load script since the number of users can grow periodically

thanx in advance

Re: Variable in Load Script

Peter_Cammaert — Mon, 09 Mar 2015 13:27:33 GMT

Check the red SET statement for awkwardly positioned quotes...

The syntax specification requires you to quote both the field name as well as the table name. But I'm not entirely sure what your shortcut is trying to accomplish here.

Re: Variable in Load Script

Anonymous — Mon, 09 Mar 2015 13:30:09 GMT

i got it my syntax had wrong quotes

this worked for me

let vLogUsersNames$(i)= peek('User',$(i),'UserAll') ;

Re: Variable in Load Script

Peter_Cammaert — Mon, 09 Mar 2015 13:32:34 GMT

That's what I meant.

Good luck, Peter