topic Re: Security and Tab Access in QlikView

Security and Tab Access

Mon, 26 Jan 2026 18:19:17 GMT

I have an App with 4 tabs. I want three people to see the first three tabs and two people to see all the tabs. Is it best to use Section Access and if so what would it look like. The other thing is I want to use NTNAME. Can someone give me some pointers?

David

Re: Security and Tab Access

mikkeltaylor — Mon, 28 Apr 2014 15:03:20 GMT

Hi David,

I am doing something similar today, but also reducing data for some users.

I'm using the link here as a guide Sheets Security with Section Access

Re: Security and Tab Access

alexpanjhc — Mon, 28 Apr 2014 18:42:43 GMT

if this is a small app, i'd just user if osuser() function for each tab

Re: Security and Tab Access

Mon, 28 Apr 2014 18:51:28 GMT

Hi Alex,

I am new to the Security part. How does the osuser work? Do you have any examples? It is a small app.

Re: Security and Tab Access

alexpanjhc — Mon, 28 Apr 2014 19:04:49 GMT

in the sheet properties->general, in show sheet check 'conditional'

assuming your users are using the exchange server to login to the system.

you can write something like

if (osuser()='david',1,0)

Re: Security and Tab Access

stevedark — Mon, 28 Apr 2014 19:19:19 GMT

Hi David,

I have uploaded a working app here: QlikView App - Show and Hide Sheets based on User or Menu

It has a user menu that allows tabs to be shown or hidden on a button click, but it also has an OSUser limitation also. The security is done in an INLINE table in the example, but you could change that to use a spreadsheet or something instead.

Hope that helps,

Steve

Re: Security and Tab Access

Mon, 28 Apr 2014 20:26:37 GMT

Hi David,

I think this can be achieved as below:

section ACCESS;

LOAD * INLINE

[ACCESS,NTNAME,FLAG123,FLAG45

USER,DOMAIN\RON,1,0

ADMIN,DOMAIN\DAVID,1,1

USER,DOMAIN\MAX,0,1];

SECTION APPLICATION;

APP:

LOAD * INLINE

[

FLAG123,FLAG45,S01,S04

1,0,1,0

1,1,1,1

0,1,0,1];

Now in Sheet show conditional you can use S01 and S04 field values to hide display as per user. e.g. =S01=1 will return for You and Ron but will return false for Max.

Please let us know if this worked.

Thanks & Regards

Suhas Gupta