topic Re: OSUser() and QVUser() in QlikView

OSUser() and QVUser()

Anonymous — Wed, 16 Dec 2015 18:44:24 GMT

I have an application which was using QVUser() USERID and PASSWORD for application security. I would then have a text box with the name of the Application as follows:

The expression in the text box is:

=If(QVUser() = 'CHITEMERERE CHRIS', 'Advanced Pharmaceutical Business Intelligence & Analytics Suite', 'Pharmaceutical Business Intelligence & Analytics Suite').

The above two text boxes show the two different situations for the expression.

I have now changed my security to NTNAME authentification. How can the same end result which i had for the application name be achieved with NTNAME security?

Regards.

Re: OSUser() and QVUser()

maxgro — Wed, 16 Dec 2015 18:55:35 GMT

did you try with osuser() to check for domain\username? it should be the same if you used above, with domain\user instead of 'CHITEMERERE CHRIS'

or subfield(OSUser(), '\', 2) if you want only the NT user

Re: OSUser() and QVUser()

Wed, 16 Dec 2015 19:03:47 GMT

OSUser uses the nt user name 9as opposed to the qlikview use) inclduing the domain name. The format of the vlue in OSUser is domain\username.

There have been some inconsistant results reported when using OSUser() function when not used in conjuction with the Upper() function.

I have used the Upper(OSUser()) quite a bit to limit access to tabs based on the person accessing the applciation

Re: OSUser() and QVUser()

Anonymous — Wed, 16 Dec 2015 19:09:07 GMT

THANK you Maxgro. I tried the following:

=If(OSUser() = subfield(OSUser(), '\', 2),'Advanced Pharmaceutical Business Intelligence & Analytics Suite', 'Pharmaceutical Business Intelligence & Analytics Suite')

The application name is:

which is not what is expected.

Re: OSUser() and QVUser()

Anonymous — Wed, 16 Dec 2015 19:13:33 GMT

Thank you Adam for the hint on use of USUser

Re: OSUser() and QVUser()

Wed, 16 Dec 2015 19:15:06 GMT

hope it helps

Re: OSUser() and QVUser()

Anonymous — Wed, 16 Dec 2015 19:20:47 GMT

Hi Adam, how would one use this Upper(OSUser()) under my situation?

Re: OSUser() and QVUser()

Wed, 16 Dec 2015 19:29:27 GMT

I have used it for security purposes in the past but for what you are showing in your original example, would somehting like this work?

=if (UPPER(OSuser())='domain\username1'
or UPPER(OSuser())='domain\usernam2'
or UPPER(OSuser())='domain\username3'
,'Advanced Pharmaceutical Business Intelligence & Analytics Suite', 'Pharmaceutical Business Intelligence & Analytics Suite')

based on the value of the OSUser, it will set the value accordingly.

Remember the value for osuser is the domain name\username where the user name is there network name (name they use when they log into their machine - yourr user name may be cchitemerer for example

Re: OSUser() and QVUser()

Anonymous — Wed, 16 Dec 2015 19:38:23 GMT

Thank you very much Adam. I used the following expression as per your recommendation:

=If(Upper(OSUser()) = 'STRATDIGM_2\Stratdigm', 'Advanced Pharmaceutical Business Intelligence & Analytics Suite', 'Pharmaceutical Business Intelligence & Analytics Suite')

with the following results:

I thought this should now read "Advanced Pharmaceutical Business Intelligence & Analytics Suite"

Regads

Re: OSUser() and QVUser()

Wed, 16 Dec 2015 19:42:24 GMT

your issue is the user portion of the OSUser is not in all capital letters

if you capitalize this portion Stratdigm - you should then get your expected result

Re: OSUser() and QVUser()

Wed, 16 Dec 2015 19:43:03 GMT

everything to the right of the = sign should be in all capital letters - you have that for the domain but not the user portion of it

Re: OSUser() and QVUser()

Wed, 16 Dec 2015 20:01:13 GMT

Christopher - did that resolve the issue

Re: OSUser() and QVUser()

Anonymous — Wed, 16 Dec 2015 20:09:43 GMT

Thanks Adam, that works

Re: OSUser() and QVUser()

Wed, 16 Dec 2015 20:10:31 GMT

Excellent - glad I was able to help

take care

Re: OSUser() and QVUser()

brooksc57 — Tue, 25 Oct 2016 17:09:21 GMT

This can come in handy as well.

you can also change your connection based on user...when necessary...

something like this.

Let L = OSUser(); //---> note: for demo purposes OSUser is server\xyz

Let C = If(L = 'server\xyz','','');

imp:

load

from

$(C)

;

I have a user that leases a license from the server and likes to see updates he has made immediately. But he doesn't need to update it live to the web server until the nightly batch. This works great for that circumstance.

Re: OSUser() and QVUser()

Fri, 28 Jul 2017 22:08:55 GMT

Thank you Adam. This also helped me greatly when I needed to hide a tab from certain users. I appreciate your help!

Re: OSUser() and QVUser()

Ravi1 — Thu, 29 Aug 2019 06:37:26 GMT

can you please provide me with detailed steps for chart level security in qlik sense using section access