Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted

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
Highlighted

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.

Partner
Partner

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;

Highlighted
Partner
Partner

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

Highlighted

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