user access levels for sheets

[#1]

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

[alexandros17]

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

Let me know

[Anonymous]

Hi,

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

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

[VishalWaghole]

Hi Shalani,

It will help you, try this

community.qlik.com/docs/DOC-5175

community.qlik.com/docs/DOC-6078

- Regards,

Vishal Waghole

[jagan]

Hi,

Check this thread, hope it helps you.

Sheet level access

Regards,

Jagan.

[#6]

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]

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.

[#8]

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 · Accepted solution]

Hi,

Try using WildMatch instead. see below,

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

[jagan]

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.