Security and Tab Access

[#1]

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

[mikkeltaylor]

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

[alexpanjhc]

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

[#4]

Hi Alex,

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

[alexpanjhc]

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)

[stevedark]

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

[#7]

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