Discussion Board for collaboration on QlikView Security and Governance.
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
Solved! Go to Solution.
In this case the expression would be:
Hi, use conditional visibility with a condition either making use of section access (with data reduction) or a condition using the osuser() function
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
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.
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
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:
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.
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?
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.
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;
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