topic Set Analysis NTNAME=OSUser() in QlikView

Set Analysis NTNAME=OSUser()

zagzebski — Sat, 26 Apr 2014 20:49:50 GMT

I am trying to write a set analysis expression that analyzes whether the NTNAME given is = to the OSUser(). It doesn't work - just keeps giving the total amount for every line whether the NTNAME = OSUser() or not.

sum ({$<NTNAME=OSUser()>} AMT)

Steve

Re: Set Analysis NTNAME=OSUser()

Sat, 26 Apr 2014 20:59:15 GMT

Steve,

try:

sum ({$<NTNAME={"=OSUser()"}>} AMT)

sum ({$<NTNAME={'$(=OSUser())'}>} AMT)

Re: Set Analysis NTNAME=OSUser()

its_anandrjs — Sat, 26 Apr 2014 21:02:40 GMT

Try to write like

=Sum ({<NTNAME={ '$(=OSUser())' }>} AMT)

=Sum ({$<NTNAME={ '$(=OSUser())' }>} AMT)

=Sum ({$<NTNAME={ "$(=OSUser())" }>} AMT)

Re: Set Analysis NTNAME=OSUser()

trey_bayne — Sun, 27 Apr 2014 02:57:54 GMT

What happens if you put =OSuser() in a text box?

Re: Set Analysis NTNAME=OSUser()

SunilChauhan — Sun, 27 Apr 2014 03:17:28 GMT

may be

youcan use below

sum ({$<NTNAME={$(=Upper(OSUser()))>} AMT)

hope this helps

Re: Set Analysis NTNAME=OSUser()

maxgro — Sun, 27 Apr 2014 16:59:42 GMT

=sum({$ <NT_NAME={"$(=OSUser())"}>} AMT)

check the domain is present in NT_NAME and OSUser()

not present in NT_NAME and not present in OSUser()

Re: Set Analysis NTNAME=OSUser()

Miguel_Angel_Baeyens — Sun, 27 Apr 2014 19:12:16 GMT

Hey,

Take into account that NTNAME is a reserved field name for section access and not visible from the model. If you want to compare current user returned by OSUser() with any other field that stores the user, make sure you are loading them in a field named different to NTNAME, otherwise, it will not work.

Miguel