Hi all
iam working on section access with NTNAME
and here in my qlik document i have 2 sheets
here my requirement is show sheets based on logged in user role through SSO
sheet 1 should be visible for manager roles
example 1: if apple1 user logged throuh SSO Sheet 1 should be visible
example 2: if apple2 user logged throuh SSO Sheet 1 should not be visible
ISSUE:
in local desktop its working fine when i uploded into publisher and i try
to access qlik document through sso iam able to see qlik dash board in access point
when i try to click on dashboard its again asking me to enter Username and password credentials how to get out of it
in ShowSheet =match(USERROLE,'MANAGER')
SCRIPT:
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, COMPANY, USERROLE
ADMIN,ADMIN,*,*
USER,APPLE1,APPLE,MANAGER
USER,APPLE2,APPLE,SUPERVISOR
USER,APPLE3,APPLE,EXECUTIVE
USER,SAMSUNG1,SAMSUNG,MANAGER
USER,SAMSUNG2,SAMSUNG,SUPERVISOR
USER,SAMSUNG3,SAMSUNG,EXECUTIVE
USER,MICROSOFT1,MICROSOFT,MANAGER
USER,MICROSOFT2,MICROSOFT,SUPERVISOR
USER,MICROSOFT3,MICROSOFT,EXECUTIVE
];
Section Application;
Roles:
Load * Inline [
Id ,USERROLE
1 ,MANAGER
2 ,SUPERVISOR
3 ,EXECUTIVE
4 ,ACCOUNTANT
5 ,ADMINISTRATORS
6 ,USERS
];
Data:
Load * Inline [
EntityId,Name,Val,COMPANY
1 ,Steve,33,APPLE
2 ,Dark,44,APPLE
3 ,Raman,33,SAMSUNG
4 ,Sanju,32,SAMSUNG
5 ,santya,232,MICROSOFT
6 ,Raj,22,MICROSOFT
];
plesese see the app for verification
Note : Pleas enable Initial Data Reduction Based On Section access while your testing and rename USERID column to NTNAME FOR YOUR TESTING(ADD YOUR DOMAIN NAME IN RECORDS )
gaballesterswuehlstevedarkloveisfailhicadamdavi3sdvqlikview
