Section Access with conditions

[anindya_manna]

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

[avkeep01]

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]

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

];