topic Re: =QVuser() vriable doesn't return a username in QlikView

=QVuser() vriable doesn't return a username

Tue, 02 Oct 2012 15:24:58 GMT

Hi Community,

I've tried to incorrporate qvuser() into my code for hidding and enabling sheets for certain users. However, it hasn't worked so far and when I made a variable with code: =QVuser() I get an empty variable.

Any ideas?

Re: =QVuser() vriable doesn't return a username

swuehl — Tue, 02 Oct 2012 15:27:45 GMT

Are you using section access?

From the Help:

QVuser( )

Returns a string containing the name of the current QlikView user as entered in a section access.

Re: =QVuser() vriable doesn't return a username

Tue, 02 Oct 2012 15:31:37 GMT

To be honest I don't know. I went to the pdf QV reference manual and it talked about section access.

I'm guessing maybe not, I do know that the server must be checking for credentials as people need to have there username added to documents in QEMC or else they can't access them.

How would I check, is there another way to see the user, perhaps for the alternative I am using?

Re: =QVuser() vriable doesn't return a username

Tue, 02 Oct 2012 15:37:19 GMT

Did you check if the QVuser() does give result when you open it from the accesspoint (where you have to login)?

I can imagine that there it works as expected, since in the accesspoint you login (with Active directory or something similar).

Re: =QVuser() vriable doesn't return a username

Tue, 02 Oct 2012 15:40:55 GMT

For us , the url for access point internally is http://rbi/qlikview/ We don't have to login, it gets the credentials from the computer we are logged into (Forgive me, I have a math and science not computer background.) We log in with Active Directory with our computers when we turn them on and can access access point without any further login info.

Re: =QVuser() vriable doesn't return a username

kamalqlik — Tue, 02 Oct 2012 15:53:32 GMT

Hi ,

In case You want to hide sheet for the Different user .

I can recommend you another method.

Go to the Sheet Properties->

In Show Sheet make it Conditional and Write the Condition=sum(SHEET1=1).

Now in the script...

write section access...statements

SECTION Access;

load USERID

FROM

(biff, embedded labels, table is Sheet2$);

left join

LOAD UPPER(USERID) AS USERID,

//PASSWORD,

ACCESS

FROM

(biff, embedded labels, table is Sheet1$);

SECTION Application;

LOAD UPPER(USERID) AS USERID,

SHEET1,

SHEET2,

SHEET3,

SHEET4,

SHEET5,

SHEET6

FROM

(biff, embedded labels, table is Sheet2$);

and now make an Excel.I am attaching the sample for Excel.

After that Go to Document properties->Check the CheckBox(Initail Data Reduction Based On Section Access).

Reload the Application.

Hope it helps.

Regards

Kamal

Re: =QVuser() vriable doesn't return a username

Tue, 02 Oct 2012 16:11:08 GMT

The only thing is that this uses an excel file, how do I link it to that internal table on my server that has the list of users?

Re: =QVuser() vriable doesn't return a username

erichshiino — Tue, 02 Oct 2012 16:31:21 GMT

Hi,

Maybe you should use OSuser( ) instead of qvuser()

QVuser() will return a user that is entered and matched with username of section access. If you don't use that field for section access, you can only retrieve the system user which is osuser()

Hope it helps,

Erich

Re: =QVuser() vriable doesn't return a username

Tue, 02 Oct 2012 16:33:09 GMT

Too funny Erich, I was just experimenting with that and got it to work!