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

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

Mon, 26 Jan 2026 18:19:17 GMT

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

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

sbaldwin — Fri, 07 Mar 2014 17:54:07 GMT

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

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

Fri, 07 Mar 2014 17:55:20 GMT

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

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

chiru_thota — Fri, 07 Mar 2014 17:58:33 GMT

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

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

maxgro — Fri, 07 Mar 2014 20:54:57 GMT

see attachment

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

Anonymous — Fri, 07 Mar 2014 21:11:05 GMT

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

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

Mon, 10 Mar 2014 13:18:00 GMT

thanks guys!

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

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

Mon, 10 Mar 2014 19:21:46 GMT

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!

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

Anonymous — Mon, 10 Mar 2014 19:32:03 GMT

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;

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

Mon, 10 Mar 2014 19:55:04 GMT

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

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

Anonymous — Mon, 10 Mar 2014 19:58:16 GMT

I see

In this case the expression would be:

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

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

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

Mon, 10 Mar 2014 20:00:18 GMT

thanks Guru!!!