Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

SECTION ACCESS FOR CONTROL 1 out of 90 sheet only group 0 n view.

Hi All

yesterday some one give me a link provide many example for my request on sheet control.

i hv found below script which control 4 sheet who can access. which is suitable for me but in my qv doc , i hv 90 sheet, only 1 sheet which i need to control , group 0 can view that sheet. all 89 sheet every one can view. how can i modify the below script , i mean i only want to list those sheet i need to control. and not to list all 89 sheet in my script. hope some one can share with me how ?

SECTION ACCESS;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, GROUP

    ADMIN, ADMINISTRATOR, ADMINISTRATOR, GROUP0

    USER, U1, U1, GROUP1

    USER, U2, U2, GROUP2

];

Section Application;

SheetSec:

LOAD * INLINE [

GROUP,          MUHASEBE,          GELIR_YONETIMI,          URETIM_PLANLAMA, REZERVASYON

GROUP0,          1,          1,          1,          1,

GROUP1,          1,          0,          0,          0,

GROUP2,          1,          1,          1,          0,

];

i hv only 9 tab , each tab have 10 sheet. example tab 1 is sales. and 10 sheet related to sales.

paul

0 Replies