Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Judicael
Partner - Contributor III
Partner - Contributor III

Section Access Table Profoles

Hello,

 

I create a section access tab:

LOAD * INLINE [

ACCESS, NTNAME, PROFILES, REDUCTION

ADMIN, ADMIN, *,*

USER, USER1,VAL

USER, USER1,GEST

USER, USER2,VAL

USER, USER1,QUAL

USER, USER1,GEST

];

APPLICATION_PROFILES:

LOAD * INLINE [

PROFILES, VALIDATOR, GESTIONNARY, QUALIFICATOR

VAL, 1,0,0

GEST, 0,1,0

QUAL,0,0,1

];

When User connect, he has profiles and flag validator, gestionnary, qualificator

Example User1 has profiles =VAL and GEST thus VALIDATOR=1 and GESTIONNARY=1

 

How can I do that ?

 

Thanks for yuour help.

Labels (1)
1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

NTNAME will contain the result of OSUser(), that is, the authenticated user reaching QlikView in the form DIRECTORY\ACCOUNT, regardless the authentication mechanism.

View solution in original post

4 Replies
Miguel_Angel_Baeyens

Your code looks good to me: you need as many lines in the section access table as reduction values you want to give to any user. In this case USER1 appears 3 times, so he will have all 3 VAL, GEST and QUAL profiles (GEST is duplicated, though).

Note that to read the appropriate value in the application and given how you defined the profiles, you will need to use Max() or similar in the application, since USER1 will have "0" and "1" for the field VAL, for example.

Judicael
Partner - Contributor III
Partner - Contributor III
Author

My section access is this : DAta REduction Works Good but I want to get the profile user with PROFILES_USERS but nothing happens. How can I fix it ?

 


SECTION ACCESS;

SECTION_ACCESS_USERS_ADMIN:
LOAD
ACCESS,
NTNAME,
PROCESS_REDUCTION,
PROFILES_USERS
RESIDENT TMP_SECTION_ACCESS;


SECTION APPLICATION;

APPLICATION_PROFILES:
LOAD
PROFILES_USERS,
RANGEMAX(IF(WILDMATCH(PROFILES_USERS,'Validator','Validateur Restreint',1,0) , 1)) AS VALIDATOR,
RANGEMAX(IF(WILDMATCH(PROFILES_USERS,'Qualificator',1,0) , 1)) AS QUALIFICATOR,
RANGEMAX(IF(WILDMATCH(PROFILES_USERS,'Gestionnary',1,0) , 1)) AS GESTIONNARY
RESIDENT TMP_SECTION_ACCESS;

 

DROP TABLE TMP_SECTION_ACCESS;

Judicael
Partner - Contributor III
Partner - Contributor III
Author

Question : NTNAME works only with DOMAIN ans LOCAL MACHINE only?

Miguel_Angel_Baeyens

NTNAME will contain the result of OSUser(), that is, the authenticated user reaching QlikView in the form DIRECTORY\ACCOUNT, regardless the authentication mechanism.