Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i trying to make a put a section access in my qlw script, but i have a problem, i wanto to make visible only some object to ntname (the windows users) when log into my qlikview project with internet explorer or firefox.
My code in my script is that:
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, PASSWORD
Admin, domani\useradmin, pwdadmin
User, domain\user_one, pwduser_one
User, domain\user_two, pwduser_two
];
Section Application;
ChartAccessMatrix:
LOAD * INLINE [
NTNAME, CH31, CH27
domani\useradmin,1,1
domain\user_one,1,1
domain\user_two,0,0];
The problem is when with my broswser i connect to the AccessPoint and make the login with USER_TWO, i see all two object i set to 0, why?
Hi,
try to follow this steps (USERID must be in Uppercase)
edited:
The problem is when with my broswser i connect to the AccessPoint and make the login with USER_TWO, i see all two object i set to 0, why?
which mean the user (USER_TWO) can see the chart object ( Object ID: CH27 )
Thanks,Deva
Because there is no connection using the NTNAME field itself, that's why you have to create a reduction field named differently, in the section access table, and use this field to reduce data for users.
Following your example, add a AUTHORIZEDUSER field (as this is not a reserved field name) in the first table with the same contents as the NTNAME field, and then use this USERNAME field in the second table (ChartAccessMatrix).
sorry i think not properly understand, so my code now is:
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, PASSWORD, AUTHORIZEDUSER
Admin, domani\useradmin, pwdadmin, domani\useradmin
User, domain\user_one, pwduser_one, domain\user_one
User, domain\user_two, pwduser_two, domain\user_two
];
Section Application;
ChartAccessMatrix:
LOAD * INLINE [
USERNAME, CH31, CH27
domani\useradmin,1,1
domain\user_one,1,1
domain\user_two,0,0];
but the same when i connect in my access point with "domain\user_two" i see the charts....
so i tried into this mode too... but same result when i connect to access poit with that user (using windows autentication), when i choice the project i want to see, it ask me the name of the user, so i put: USER_TWO, but the USER_TWO show again the 2 charts...... i need not show for this user... i think the code in script is ok:
Section Access;
LOAD * INLINE [
ACCESS, USERID
Admin, USERADMIN
User, USER_ONE
User, USER_TWO
];
Section Application;
ChartAccessMatrix:
LOAD * INLINE [
USERID, CH31, CH27
USERADMIN,1,1
USER_ONE,1,1
USER_TWO,0,0];
Hi,
Please refer to the attached sample. have u done with conditional display chart option? if not u have to set like below
1) go to settings--> document properties ---> opening --> enable below check box
2) conditionally display on chart 31
3) conditionally display on chart 27
4) then u can try to close and re-open u r qlikview document then it will prompt user ID (try to check below ID & it should work as mentioned below -tested fully.)
LOAD * INLINE [
USERID, CH31, CH27
USERADMIN,1,1
USER_ONE,1,1
USER_TWO,0,0
USER_THREE,0,1];
Hope it helps
Thanks
Deva
Use UPPERcase for both field names and values in both section access and data tables. That should work.
See example attached (don't save the file!):
User with permissions: USER1 password USER1
User without permissions (no chart): USER2 password USER2