topic Re: Hiding Tabs via Section Access in QlikView

Hiding Tabs via Section Access

brf10043 — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Hiding Tabs via Section Access

alexdataiq — Thu, 02 Jun 2016 23:05:12 GMT

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

Re: Hiding Tabs via Section Access

brf10043 — Thu, 02 Jun 2016 23:32:07 GMT

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.

Re: Hiding Tabs via Section Access

brf10043 — Fri, 03 Jun 2016 00:02:12 GMT

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?

Re: Hiding Tabs via Section Access

muthukumar77 — Fri, 03 Jun 2016 13:08:56 GMT

Hi,

Please create hidden script in Edit Script.

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

Re: Hiding Tabs via Section Access

paulyeo11 — Mon, 22 Jun 2020 02:14:26 GMT

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