Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Conditional show on Sheet

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?

10 Replies
vijay_iitkgp
Partner - Specialist
Partner - Specialist

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.