topic Re: A problem with OsUser() function in QlikView

A problem with OsUser() function

Anonymous — Thu, 05 Nov 2015 13:17:33 GMT

Hello,

the OsUser() function returns to me "domain sername" instead of "domain\Username".

Has anyone ever had the same problem?

Thanks.

Re: A problem with OsUser() function

Clever_Anjos — Thu, 05 Nov 2015 13:22:37 GMT

First, try =OSUser() using a textbox, same issue?

Re: A problem with OsUser() function

Anonymous — Thu, 05 Nov 2015 13:22:51 GMT

nope, wud return User name only

Re: A problem with OsUser() function

Mark_Little — Thu, 05 Nov 2015 13:23:45 GMT

Hi,

Not a issue i have come a across. If it is causing an issue a work around could be

=Replace(OSUser(),' ','\')

Hope this helps

Mark

Re: A problem with OsUser() function

Anonymous — Thu, 05 Nov 2015 13:30:46 GMT

Yep, Clever

Re: A problem with OsUser() function

Anonymous — Thu, 05 Nov 2015 16:59:07 GMT

Hi Mark,

your workaround fixes only one of the two problems: the OsUser() functions losts the "\" AND the first charater of the username.

(To be very accurate it lostd the "\" and the first char of the user AND it replace it with a <return> char!!)

Pls have a look to my screenshot

Re: A problem with OsUser() function

Thu, 05 Nov 2015 17:05:06 GMT

I just used the =OSUser() function in a text box and it returnedfor me what I believe you are expecting - domainname\username

the only difference I see is my username is a single name without the period, which should not cause an issue

Re: A problem with OsUser() function

swuehl — Thu, 05 Nov 2015 17:13:31 GMT

Does this issue only happen when the first char is 'n'? Then '\n' is interpreted as line break.

What if you write:

=OSUser() = 'NETSIMEC\nicola.perrone'

does it return true or false?

Re: A problem with OsUser() function

beck_bakytbek — Thu, 05 Nov 2015 17:18:20 GMT

Hi edp,

you can use this function on the base of Excel-sheet:

= only({<Your Domane ={"$(=OSUser())"}>}>YourDomaneUsername. First: Column in your Exel is YourDomane, and the second Column in your Excel-Shet: YourDomaneUsername. It is straithforward. so you can concatenate your DomaneName with your DomaneUsername. and this Expression can be used in textobject.

i hope, that helps

kindly Beck

Re: A problem with OsUser() function

swuehl — Thu, 05 Nov 2015 17:31:31 GMT

Try

=UPPER(OSUSER() )

Re: A problem with OsUser() function

Thu, 05 Nov 2015 17:33:40 GMT

in the sample textbox, i used OSUser, but in the condition of my sheets, I have used what others have suggested which is

UPPER(OSUser())

Re: A problem with OsUser() function

Anonymous — Fri, 06 Nov 2015 07:43:14 GMT

A great intuition, Swuehl, my compliments!

Re: A problem with OsUser() function

Anonymous — Fri, 06 Nov 2015 07:44:26 GMT

With the Upper function it works fine!!

Thank you so much!

Re: A problem with OsUser() function

Anonymous — Fri, 06 Nov 2015 07:45:28 GMT

Thank you, Adam....your suggestion is right 😉