Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Partner
Partner

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

Tags (1)
2 Replies
Partner
Partner

Re: Section Access with conditions

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;

Partner
Partner

Re: Section Access with conditions

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

];