What is the difference between OSUSER() and NTNAME in qlikview?
hi,
I want to use section access in my application. I want that a particular user cannot see some object and some particular user will not see some data. How how can I implement this in QlikView?
I have 'CountryID' field and I want that when SANDIP will logged in he can see 1 and when admin logged in he will see all the listed values.
For data reduction I have used the following script:-
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, %CountryID
ADMIN, ADMIN, ADMIN123, *
USER, SANDIP, SANDIP123, 1
];
Section Application;
LOAD * INLINE [
%CountryID, CountryID
1, 1
2, 2
3, 3
];
But for both user I am viewing all the countryid in the list box.
For examples 3 users are A,B,C now user A and User B will see the data and User C will not able to see the data for that purpoes we have to provide the section access,and section application.
section access--building the the security for data
setion application-allowing the user what to see and what not to see..
section access:
access userid,password
admin,admin,admin
user,user1,user2
user,user2,user2
section application
userid,omit
admin,"*"
user1,'A'
user2 'B'
using this will able to see the A and B users only.
I believe %CountryID field name must be upper case to work: %COUNTRYID, also note that star symbol means 'all listed values' (with section access), not all possible values of that field. If you want ADMIN to see everything, remove the star from %COUNTRYID field in section access.
instead of using capital %COUNTRYID, in section access I have used CountryID, USERID fields in application section. and it works. But whenever I have put the * instead of mentioning the COuntryId value, in list box * is appearing.
instead of using capital %COUNTRYID, in section access I have used CountryID, USERID fields in application section. and it works. But whenever I have put the * instead of mentioning the COuntryId value, in list box * is appearing.
