topic Re: QVUser() value not refreshed in QlikView

QVUser() value not refreshed

Mon, 21 Sep 2015 14:18:06 GMT

Hi ,

Im trying to load login user name to a table i.e qvuser() to a table.

Code -

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REGION

ADMIN, ADMIN, ADMINPASS, *

USER, USER1, USER1, USA

USER, USER2, USER2, CANADA

USER, USER3, USER3, EUROPE

];

LET vVar=QVUser();

user_info:

LOAD * Inline [

USER NAME

$(vVar)];

The above code always returns me "ADMIN" rather than USER names. "ADMIN" in which the app was saved first time. Jus to cross check the function , I added a textbox with qvuser() and it is appearing properly.

Can any help me tel me why this behaviour

Re: QVUser() value not refreshed

Peter_Cammaert — Mon, 21 Sep 2015 14:31:56 GMT

Probably because the only one who can perform a reload is ... ADMIN. Users with role=USER usually have the Reload-button disabled.

Peter

Re: QVUser() value not refreshed

Tue, 22 Sep 2015 02:34:19 GMT

After reload , the value gets updated. The scenario which Im trying is without reload the application . I want to join logged in user id to another internal user table.

Is there any way I can get USERID

Re: QVUser() value not refreshed

Peter_Cammaert — Tue, 22 Sep 2015 07:31:31 GMT

The difficulty you are facing is that during script execution all USERIDs are valid because a USERID is only significant when you open a document in the AccessPoint (or QV Desktop). At that moment, it's too late to start concatenating tables.

Maybe concatenating all USERIDs to your other table in section application anyway, and then using data reduction (which comes into action at Document-Open-time) to throw out all unwanted USERIDs may solve your case? You will have to perform a Cartesian product with all the Users that are already present in the second table, in order to avoid them getting wiped out by the data reduction. That could work just fine. But I don't know enough about your data model to provide you with a ready-to-use-example. [Edit] Check the attachment.

Does this untested example help?

SA_Source:

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REGION

ADMIN, ADMIN, ADMINPASS, *

USER, USER1, USER1, USA

USER, USER2, USER2, CANADA

USER, USER3, USER3, EUROPE

];

Section Access;

SA:

LOAD * RESIDENT SA_Source;

Section Application;

SecondUserTable:

LOAD * INLINE [

USERID2

USER4

USER5

USER6

];

JOIN (SecondUserTable)

LOAD USERID RESIDENT SA_Source;

CONCATENATE (SecondUserTable)

LOAD USERID, USERID AS USERID2 RESIDENT SA_Source;

DROP Table SA_Source;

I became very curious about linking to USERID, so I tested it myself before posting. It seems to do the job...

Best,

Peter

Re: QVUser() value not refreshed

Tue, 22 Sep 2015 11:19:28 GMT

Thanks Peter , Im able to get the user ID with your script.