Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
if this is a small app, i'd just user if osuser() function for each tab
Hi Alex,
I am new to the Security part. How does the osuser work? Do you have any examples? It is a small app.
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)
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
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