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: 
Not applicable

user access levels for sheets

hi

in my program i have 4 sheets. the problem i have is i want to make only 2 sheets public and give the other two sheets user access level

is this possible ??

i would really appreciate if some one could help me out in this plz

thank you in advance

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi,

Try using WildMatch instead. see below,

=WildMatch(OSUser(), '*sampath*', '*niromal*', '*nalaka*')

View solution in original post

9 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Add a vidsibility condition to your sheet using the OSUser() instruction....

Let me know

Anonymous
Not applicable
Author

Hi,

In conditional show sheet, you can add below condition to enable sheet only for those users.

=Match(OSUser(), 'User1', 'User2', 'User3')

VishalWaghole
Specialist II
Specialist II

Hi Shalani,

It will help you, try this

community.qlik.com/docs/DOC-5175

community.qlik.com/docs/DOC-6078

- Regards,

Vishal Waghole

jagan
Luminary Alumni
Luminary Alumni

Hi,

Check this thread, hope it helps you.

Sheet level access


Regards,

Jagan.

Not applicable
Author

hi Satyadev

after giving this condition the page gets hidden how can i get this visible or how can the particular user c this??

Anonymous
Not applicable
Author

Hi,

You need to go to Settings --> Document Properties --> Sheet tab --> double click on conditional hidden sheet and add your system id so that it can be visible to you.

OSUser() function identify the users system id and base on condition, the sheet will visible for them.

Not applicable
Author

my user name of the matching is "sampath" so this is how my function goes but the pages are not visible to me

=Match(OSUser(), 'sampath', 'Niromal', 'Nalaka')

Anonymous
Not applicable
Author

Hi,

Try using WildMatch instead. see below,

=WildMatch(OSUser(), '*sampath*', '*niromal*', '*nalaka*')

jagan
Luminary Alumni
Luminary Alumni

Hi,

Check below thread which helps you.

Sheet level access


When you use OSUser() you will get domain/name format, so use Wildmatch() instead of Match()


=WildMatch(OSUser(), '*sampath*', '*niromal*', '*nalaka*')


Check OSUser() in a text object and give values in WildMatch() according to that.


Regards,

Jagan.