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?

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi Pradeep,

Load user names from Excel file

LOAD

UserName

FROM ExcelFile;

=Len(Only({<UserName={'$(=OsUser())'}>} UserName)) > 0


Hope this helps you.


Regards,

Jagan.

View solution in original post

10 Replies
narband2778
Creator II
Creator II

Hi,

Use Mixmatch() function as shown below

=mixmatch(osuser(), 'user1','user2', 'user3')>0

regards,

Naresh

jagan
Luminary Alumni
Luminary Alumni

Hi Pradeep,

Try Match()

If(Match(OSUser(), 'user1', 'user2' , 'user3', 'user4', 'user5', .............'usern'),1,0)

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Anonymous
Not applicable
Author

can we make usernames configurable?

i mean can we put all the usernames in one excel file and can we use the same in conditional show without writing all the usernames in condition?

Anonymous
Not applicable
Author

Hi Jagan,

can we make usernames configurable?

i mean can we put all the usernames in one excel file and can we use the same in conditional show without writing all the usernames in condition?

jagan
Luminary Alumni
Luminary Alumni

Hi Pradeep,

Load user names from Excel file

LOAD

UserName

FROM ExcelFile;

=Len(Only({<UserName={'$(=OsUser())'}>} UserName)) > 0


Hope this helps you.


Regards,

Jagan.

DavidFoster1
Specialist
Specialist

This doc in the resource library

Sheets Security with Section Access

Is a very good reference for what you are trying to do. Basically you create a tick sheet for each user. If you aren't using section access then you will need to add the OsUser() calculation to set analysis in the sheet visibility.

jagan
Luminary Alumni
Luminary Alumni

Hi,

Check this link, hope it helps you.

Sheet level access

Regards,

Jagan.

amit_saini
Master III
Master III

Pradeep,

Go to sheet properties-> condition and use this condition below:

OSUser() = 'ABC' or OSUser() = 'XYZ' or OSUser() = 'HJX'

Thanks,

AS

Anonymous
Not applicable
Author

It's Working,

Thank you