topic Re: user access levels for sheets in QlikView

user access levels for sheets

Tue, 08 Jul 2014 08:21:25 GMT

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

Re: user access levels for sheets

alexandros17 — Tue, 08 Jul 2014 08:24:50 GMT

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

Let me know

Re: user access levels for sheets

Anonymous — Tue, 08 Jul 2014 08:25:54 GMT

Hi,

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

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

Re: user access levels for sheets

VishalWaghole — Tue, 08 Jul 2014 08:27:34 GMT

Hi Shalani,

It will help you, try this

community.qlik.com/docs/DOC-5175

community.qlik.com/docs/DOC-6078

- Regards,

Vishal Waghole

Re: user access levels for sheets

jagan — Tue, 08 Jul 2014 08:38:07 GMT

Hi,

Check this thread, hope it helps you.

Sheet level access

Regards,

Jagan.

Re: user access levels for sheets

Tue, 08 Jul 2014 12:08:23 GMT

hi Satyadev

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

Re: user access levels for sheets

Anonymous — Tue, 08 Jul 2014 12:27:56 GMT

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.

Re: user access levels for sheets

Tue, 08 Jul 2014 12:56:34 GMT

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')

Re: user access levels for sheets

Anonymous — Tue, 08 Jul 2014 13:09:39 GMT

Hi,

Try using WildMatch instead. see below,

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

Re: user access levels for sheets

jagan — Wed, 09 Jul 2014 04:04:33 GMT

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.