Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an app, that everyone should to be able to access. But I need to OMIT a field for everyone, except a handful of users. I don't want to have to list every single user with OMIT <field> (except the handful). Is there anyway to omit for all users except a few named ones?
I wondered if I could use the solution below. User 1 and 2 are the users that should be able to see the field, that is omitted for everyone else.
Section Access;
LOAD * Inline [
"ACCESS" , "USERID" , OMIT
USER, *, FIELDNAME
ADMIN, INTERNAL\SA_SCHEDULER,
ADMIN, USER1,
ADMIN, User2,
];
Section Application;
Try
Section Access;
LOAD
If(CAN_SEE_EVERYTHING='YES','','FIELDNAME') as OMIT,
*
Inline [
ACCESS, USERID, CAN_SEE_EVERYTHING
USER, OTHERUSER1,
USER, OTHERUSER2,
ADMIN, INTERNAL\SA_SCHEDULER, YES
ADMIN, USER1, YES
ADMIN, USER2, YES];
Hi @hic , thanks for the reply.
Will you be kind and explain the logic behind your solution ? And why your solution is better than mine ? This is my first time using section access and I need a little help understanding this 🙂
For instans, I dont understand why I should list some other users ( OTHERUSER1 and OTHERUSER2) instead of just using a * ? I have around 5000 (other) users that should have access to the app and see everything except one field, so I cant list all the other users.
It may well be that your solution works excellently. Try it!
I misunderstood you - I thought you wanted to avoid the wildcard, since an authorized user then has two ways of getting into the app: Both through the wildcard and through the explicit user name.
Ok thanks again, @hic . It is probably my bad english, that is causing misunderstandings:)
My solution seems to work, when I test it. I am just a little worried, because the field i am trying to hide for all except a few contains confidential information. And according to this post, what I am trying to do is not possible: https://community.qlik.com/t5/QlikView-Administration/Section-Access-OMIT-White-List/td-p/942673
But that post is old and it is Qlikview.