Conditional show on Sheet

[Anonymous]

Hi,

I have to show one sheet for only some people, rest of the sheets can see everyone. Here i am using osuser() function in conditional show like: =

=if(OSUser()='user1' or OSUser()= 'user2' ,1,0). This is working fine, but i have to show this for 30 users and in future it may increase, how can i do this without section access?

[vijay_iitkgp]

Hi Pradeep,

You must have Users information stored somewhere in table/ qvd/excel. You can cretae one table in application with concatenated field (0say User) of all users which you want to give access and then use expression

Substringcount(OSUser,User)>0

Ex:

If you have table

UserList:

UserName

A,

B,

C

From XYZ.qvd;

Load

Concat(UserName) As UserName

From XYZ.qvd;

Hope this help.