Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section access not identifying QVuser in QV 9.0

Hi,


script:


Section Access;

STAR IS *;

LOAD * INLINE [

ACCESS,NTNAME,COLUMN1

ADMIN, QLICKVIEWSERVERLOGIN, *

ADMIN, LOGIN1, *

USER, LOGIN2, DIMESION_VALUE

];

Section Application;

............ and so on

Now when I reload I see everything (I am login1)

but when I close and open qlikview I see only as

login2.In OSuser() I see my login as I should, but in

QVuser() I see nothing.Any ideas?

3 Replies
Anonymous
Not applicable
Author

(Was looking an answer for my own problem, and came upon this unanswered post. Probably you have the answer already by this time. Anyway...)
OSUser() returns the result of NTNAME.
QVUser() returns result of USERID.
You're not using USERID - it's not needed here. That's why there is nothing in QVuser().
It has nothing to do with QV 9, all versions work the same way.

Not applicable
Author

If your user login1 need to see all values of field column1 you don't have to user * (star) but Null (leave the field empty).

QVuser() is for section access defined users
OSuser() is for windows users

LOAD * INLINE [
ACCESS,NTNAME,COLUMN1
ADMIN, QLICKVIEWSERVERLOGIN, *
ADMIN, LOGIN1,
USER, LOGIN2, DIMESION_VALUE
];

Not applicable
Author

Yes,

this was actually the issue, thanks Corrado.