Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How I can deny access to certain objects in page for some users?

Hi,

Please, I need you help me with that: How I can deny access to certain objects in page for some users?

In my page I have several objects (charts, tables, buttons) that I need disable for some users.

Thanks in advance

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: How I can deny access to certain objects in page for some users?

I see

In this case the expression would be:

=not wildmatch(OSUser(),'*loginname1','*loginname2')

or

wildmatch(OSUser(),'*loginname1','*loginname2')=0

11 Replies
sbaldwin
Contributor III

Re: How I can deny access to certain objects in page for some users?

Hi, use conditional visibility with a condition either making use of section access (with data reduction) or a condition using the osuser() function

Thanks

Steve

Not applicable

Re: How I can deny access to certain objects in page for some users?

Nancy,

There is no mechanism in QV to do that. You will have to "code" it.

1) Section Access

2) For each object, there is a conditional show sth like

OSUser='xxxx'

sum(XXX)> 1  (see doc)


See the document attached. It is a little old, but it works fine. See especially page 17. It is for the sheet, but you can transpose it to individual objects.

Fabrice

chiru_thota
Valued Contributor

Re: How I can deny access to certain objects in page for some users?

you can use osuser() as steve mentioned.

Below screenshot is showing how to do it for sheet .but same can be done for different objects

Layout --> Conditional

Tab security.jpg

MVP
MVP

Re: How I can deny access to certain objects in page for some users?

see attachment

mov
Esteemed Contributor III

Re: How I can deny access to certain objects in page for some users?

Chiru,

This is certainly correct, I just prefer wildmatch() function.  It is not case sensitive, and no need to type domain part (because can use *), get much shorter expression:
=wildmatch(OSUser(),'*loginname1','*loginname2')

And it is not necessary use ">0" because if current user matches, the function returns result >0 which is "true".  If there is no match, it returns 0 which is "false" and the object is hidden.

Regards,

Michael

Not applicable

Re: How I can deny access to certain objects in page for some users?

thanks guys!

I am reviewing all your answers and I tell you later how I did it.

Not applicable

Re: How I can deny access to certain objects in page for some users?

Hi Chiranjeevi and Michael,

Thanks for your suggestions, but these match and wildmatch functions are for enable acces to users loginname1 and loginname2. I need disable access for users.

Any hint for this?

Thanks!

mov
Esteemed Contributor III

Re: How I can deny access to certain objects in page for some users?

Nancy,

In the example, access is disabled for all users except loginname1 and loginname2.  I assume there will be at least one user with access - so this one user will be in this expression.

Regards,

Michael

Edit:  If you want to disable access for all users without exceptions, but still want to keep this object for some reason, set show condition to 0;

Not applicable

Re: How I can deny access to certain objects in page for some users?

Michael,

It is the opposite. I need disable the access for 2 users and enable access for many other users. Too many users as to include in a list