Section Access with multiple table.

[ashmitp869]

Hi All,

I am working on section access -

I have two table in Data model SE and OOS and the linkage is with linkagekey -

But my section access wotks on SE.Masked Derived National Service ID and I have created the section access for SE table and its working well. But How to work the same logic for OOS table - 

OOS table have  SE.Masked Derived National Service ID and the fields are almost same but prefix with OOS

Attaching the Data Model in word doc.

Any suggestion will be highly apprectiated.

Thanks in advance.

[ashmitp869]

I tried to seperate the SE and OOS table but there is a loop creation with the AUTHGRP color with black.

[vchuprina]

Hi,

Maybe it makes sense to create a link table based on SE and OOS. And then link Authtable to link table.

Regards,

Vitalii

[ashmitp869]

Hi Vitalii,

I tried as you recomended. but there is a syn key formation as I mention SE and OOS are join with linkagekey so when trying to join with other field "Masked Derived National Service Event Record Id"  is forming syn table

[ashmitp869]

After forming the key , do I drop the field from OOS and SE ? will it the join work  with SE and OOS

[ashmitp869]

Hi Vitalii,

I have tried this linking table

But its giving me this result

but my actual report with out section access is like below -

[vchuprina]

Hi,

Check this article

https://www.learnallbi.com/link-table-in-qlikview/

Yes, you should remove common fields from tables once you load them to Link table

Regards,

Vitalii