Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Not applicable

Security and Tab Access

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

6 Replies
mikkeltaylor
Contributor II

Re: Security and Tab Access

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
Valued Contributor

Re: Security and Tab Access

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


Not applicable

Re: Security and Tab Access

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
Valued Contributor

Re: Security and Tab Access


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)

MVP
MVP

Re: Security and Tab Access

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

Not applicable

Re: Security and Tab Access

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

Community Browser