Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
brf10043
Creator
Creator

Hiding Tabs via Section Access

Hi guys,

I am struggling with setting up section access that restricts the tabs seen by different user groups.  I've done this before and gotten it working, but I can't seem to get this one to behave.

Here is my Section Access Script.  I'm trying to hid Tab SH11 for GROUP2

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, GROUP
ADMIN, WMSERVICE\OAX65894, ALL
ADMIN, WMSERVICE\OAX33106, ALL
ADMIN, WMSERVICE\OAX48771, ALL
ADMIN, WMSERVICE\OAX91092, ALL
ADMIN, WMSERVICE\BRF10043N, ALL
ADMIN, WMSERVICE\DOB18504N, ALL
//ADMIN, WMSERVICE\SG-Orion_Admin, ALL
//USER, WMSERVICE\SG-ITLT_Dashboard_Access, GROUP1
//USER, WMSERVICE\SG-ITLT_Dashboard_Restricted_Access, GROUP2
//USER, WMSERVICE\SG-Orion_Access, GROUP2
USER, WMSERVICE\CCL29279, GROUP2
]
;

Section Application;

SheetAccess:

LOAD * INLINE [

GROUP, SH06, SH02, SH12, SH03, SH09, SH10, SH08, SH07, SH05, SH11
ALL, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
GROUP1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
GROUP2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0
]
;

Document Properties are set for Initial Selection based on Section Access

Each tab has the following Condition

My Security Tab in the Dec Properties is set as follows

and my Reload setting in the QMC looks like this

What am I Missing here?

5 Replies
alexdataiq
Partner - Creator III
Partner - Creator III

Well the settings seems OK. If you open the application as WMSERVICE\CCL29279 the sheet gets displayed? Are you accesing through the Access Point? Or if you're using QV Desktop are you closing and re-opening the app after a reload?

Cheers

brf10043
Creator
Creator
Author

So, I am trying both.  When I open on the desktop client as WMSERVICE\CCL29279, I see all the tabs, but I no longer have access to the load scripts which tells me that it's recognizing the log in as a user instead of admin but I still see SH11.  When I access via the Access Point.  I also see everything.

brf10043
Creator
Creator
Author

So this is interesting.  I switched to Initial Data Reduction Based on Section Access.  It had been set to Initial Selection Based on Section Access.

It now works perfectly as long as I open with the desktop client.  It does not work when I open via Access Point.  I run the reload and distribute task and still see all the tabs even though I'm logged in as the correct user.

Thoughts?

muthukumar77
Partner - Creator III
Partner - Creator III

Hi,

Please create hidden script in Edit Script.

Go to "Edit Script" , Click File -> Create Hidden Script. With password

Muthukumar Pandiyan
paulyeo11
Master
Master

Hi Sir

can you pls share with me where to locate below setting.

Go to "Edit Script" , Click File -> Create Hidden Script. With password

Paul