Preventing a selection in a chart from working on a table
I have a Qlik Sense dashboard that uses a table to display the employees' information. For example, only certain users are allowed to see the Ethnicity column. Using Section Access and OMIT, that is working properly.
The problem is I also need to display Ethnicity in a line chart. So I added another field, ChartEthnicity, and I use that in the chart. That also seems to work.
The next issue is that the users can click on one of the Ethnicity lines and it filters everything (as it should). However, I need to prevent the selections (on some fields) made in the chart from working. Otherwise, the users would be able to determine, in the detail table, which Ethnicity the employees are.
How can I have fields that are only available to select users but still show those fields in a chart? (I guess I solved that one?) Additionally, how can I make it so some of the selections made in the chart do not filter on the table?