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

[fabdulazeez]

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?

[G3S]

try alternate state:
https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Visualizations/alternate-...

[G3S]

or ignore selection thru set analysis

[fabdulazeez]

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.