Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
fionna51
Creator
Creator

Search value from reference table

Hi,

I want to show one critical object only to certain users. I can get user's Entity_ID when user login (unique for every user) . Also, I load an island reference table which contains list of eligible entity IDs who can see this object, field name Eligible_ID.

In this object Layout tab, how should I write the condition?

4 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

You could use osuser() for this, like:

match(osuser(), '$(=concat(YourUserlistField, chr(39) & ',' & chr(39)))')

but if your data/objects are really confidential then you should consider to use Section Access.

- Marcus

fionna51
Creator
Creator
Author

Hi Marcus,

My Entity_ID was derived from user_id, the data type is exactly same as Eligible_ID in my reference list. But if I use:

match(Entity_ID, Eligible_ID), it won't work. One user only has one Entity_ID value, but Eligible_Id is a list of values.

Thanks a lot.

marcus_sommer
MVP & Luminary
MVP & Luminary

My Entity_ID was derived from user_id

isn't quite clear to me - from where come these values. For reading the current user there are only two functions: osuser() and qvuser().

The concat-function within $-sign expansion will return a list from your user-table - therefore try:

match(osuser(), '$(=concat(Eligible_ID, chr(39) & ',' & chr(39)))')

further you should check if the osuser() returned the same user like in your user-table - you might need to adjust upper/lower chars and also the domain\user.

- Marcus

fionna51
Creator
Creator
Author

We have built section access with security_key, then can use substring() to get proper segment for user's entity. One user can only have one entity, for example hospital Stony Brook. Also we have a list contains eligible entities. Only hospital in this list can see the object.

Thanks.