Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I tried to seperate the SE and OOS table but there is a loop creation with the AUTHGRP color with black.
Hi,
Maybe it makes sense to create a link table based on SE and OOS. And then link Authtable to link table.
Regards,
Vitalii
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
After forming the key , do I drop the field from OOS and SE ? will it the join work with SE and OOS
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 -
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