topic Re: Section Access with multiple table. in QlikView

Section Access with multiple table.

ashmitp869 — Wed, 20 Apr 2022 11:18:31 GMT

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.

Re: Section Access with multiple table.

ashmitp869 — Wed, 20 Apr 2022 11:22:31 GMT

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

Re: Section Access with multiple table.

vchuprina — Wed, 20 Apr 2022 11:27:45 GMT

Hi,

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

Regards,

Vitalii

Re: Section Access with multiple table.

ashmitp869 — Wed, 20 Apr 2022 21:50:19 GMT

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

Re: Section Access with multiple table.

ashmitp869 — Wed, 20 Apr 2022 21:52:55 GMT

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

Re: Section Access with multiple table.

ashmitp869 — Wed, 20 Apr 2022 23:26:40 GMT

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 -

Re: Section Access with multiple table.

vchuprina — Thu, 21 Apr 2022 07:54:57 GMT

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