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: 
anindya_manna
Partner - Creator II
Partner - Creator II

Section Access with conditions

Hi All,

I have million of User who will login to Qliksense app and i have field name Status which have 'Completed' and 'Active' values.

Out of million User ID , i wan to give access to 4 User ID('A','B','C','D') for both status so that they can see all data associated with both 'Completed' and 'Active' and for remaining User IDs , i want to restrict them to see only data associated with 'Active' Status.

problem is that , i have information only about Those 4 User IDs for which i need to give both value access. For rest of them i need to restrict the access.

Thanks

2 Replies
avkeep01
Partner - Specialist
Partner - Specialist

Hi Anindya Manna,

You could try the following:

First only load the users which should see the completed values. And then add all the other users (including the earlier loaded 4) with "active" as value.

SectionAccessTable:

LOAD

USERID,

'Completed' AS STATUS

FROM USERID_Table

WHERE MATCH(USERID,'USERID1','USERID2','USERID3','USERID4');

CONCATENATE (SectionAccessTable) LOAD

USERID,

'Active' AS STATUS

FROM USERID_Table;

stigchel
Partner - Master
Partner - Master

I think you can use * for NTNAME, so you give access to both for those four users and restrict for all the rest like this

Please note the DUMMY user, it is needed to give access to COMPLETED for users A,B,C,D

Section Access;

Load * Inline [NTNAME,ACCESSGROUP

A,*

B,*

C,*

D,*

*,ACTIVE

DUMMY,COMPLETED

];

SECTION Application;

star is *;

Load * Inline [ACCESSGROUP

ACTIVE

COMPLETED

];