Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
twanqlik
Creator
Creator

Section Access - hide a field based on the value in another table

I'm struggling with Section Access:

Goal: I want to make the 'Email' Field visible for Dashboard users that have a specific value in the 'Business Group'.

The rest of the fields in the Master_Users table should always be visible to all the dashboard users.

I don't think this is possible with Section Access.

Sense delete.png

5 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

It should be possible to control the visibility of this field with section access if you filled there the field OMIT with Email or leaving it blank based on the data in BUSINESS_GROUP: Introduction to Section Access.

- Marcus

twanqlik
Creator
Creator
Author

I already have read the introduction to section access page, but couldn't find a way to accomplish this.

marcus_sommer
MVP & Luminary
MVP & Luminary

Take a look on the example 5 there on page 17.

twanqlik
Creator
Creator
Author

With Omit, the field will be hidden, but i want to hide values in the field itself.

marcus_sommer
MVP & Luminary
MVP & Luminary

Now I understand what do you want to do but it's not possible with the "standard" logic of section access which allowed the visibility of a column and/or a record for an user or not but nothing in between them.

This means you need some additionally measures to get it. This could be to use two different mail-fields and depending of which field is available within the datamodel it will be displayed within the UI (the field could be replaced through a variable in which such a check is applied). Quite similar is the approach of duplicating the records and one record has a mail-value and the other is blank and per your field BUSINESS_GROUP you controls which of the records will be reduced.

Another way could be to Mask or de-identify data for certain users using Section Access.

- Marcus