Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ashu_this_side
Contributor
Contributor

Sheet level section access for same user.

Hi all,
I have one issue while giving sheet level section access to user where I have to give ALL PLANTS access of  Sheet1 to 50004579@ABC.COM and give P002,P003,P004 plants access to same user (50004579@ABC.COM )for Sheet2.
(Note: We are using different source for both sheet and later concatenated)


Section Access;
SA_TAB:
LOAD
ACCESS,
USER.EMAIL,
SHEET_CONTROLLER AS SHEET_CONTROLLER,
SUBFIELD(PLANT,'|') AS PLANT,
PLANT AS PLANT_SA
Inline
[
ACCESS,        USER.EMAIL,                                     PLANT,                      SHEET_CONTROLLER
ADMIN,          MMKNDQLIKVIEW@ABC.COM,         ALL,                           ALL
ADMIN,          AFSQSENSEADMIN@ABC.COM,       ALL,                           ALL
ADMIN,         50004383@ABC.COM,                         ALL,                            ALL
USER,           50004579@ABC.COM,                         ALL,                            1
USER,           50004579@ABC.COM,                        P002|P003|P004,        2
];
Section Application;

Sheet_Access:

Load * Inline
[
SHEET_CONTROLLER
1
2
12
ALL
];

In sheet we have given Show condition 
for Sheet1 
=SHEET_CONTROLLER=1 or SHEET_CONTROLLER ='ALL' 
for Sheet2
=SHEET_CONTROLLER=2 or SHEET_CONTROLLER ='ALL' 


 

Labels (4)
0 Replies