Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
fabdulazeez
Partner - Creator III
Partner - Creator III

How to Show Unrelated data in Qlik Sense While Applying Section Access

I have below scenario  and would like to get suggestions on data modeling

Message Table:

 

  • MessageID
  • MessageContent
  • TrainID (nullable)

Train Table:

  • TrainID
  • Terminal

I need to apply section access on Terminal and display all messages (both related to train and unrelated) on the same screen with  common filters. When I apply section access to the terminal, all the rows in the Message table that are not related to train become unavailable, which I believe is expected behavior.

What could be  correct approach to achieve this?

 

Labels (3)
4 Replies
G3S
Creator III
Creator III

or ignore selection thru set analysis

fabdulazeez
Partner - Creator III
Partner - Creator III
Author

When section access is applied, it filters out data based on user permissions when the app is opened. So I believe , alternate states or set analysis cannot be applied to data that is not available due to these restrictions.It will require a change at the data model level. Currently, I set the value of null TrainID to 'NA' in the message table and append a dummy row with 'NA' in the Train table. I then update section access to grant all users access to this dummy data row.I would like to understand a better approach.

marcus_sommer

I think you have already applied the best approach by replacing the NULL with a real value within this KEY field.