Qlik Community

Qlik Sense App Development

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

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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

Highlighted
Creator
Creator

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

Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted
Creator
Creator

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

Highlighted
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