https://community.qlik.com/t5/QlikView/Section-Access-match-two-fields/m-p/2005242#M1221517 <P>Hi,</P> <P>Take a look at the attached. It should help you on this.<BR /><BR /><BR /></P> Wed, 16 Nov 2022 11:28:19 GMT Bill_Britt 2022-11-16T11:28:19Z https://community.qlik.com/t5/QlikView/Section-Access-match-two-fields/m-p/2005003#M1221508 <P>Hi, We have a business requirement. The scope is that if an user key can match either table key1 or key2 who could access this row.&nbsp; For instance: The key of A is 1001 so he can get ID 1 and ID2 of OR Table ,The key of B is 1002 so he can get ID 2 and ID 3 so on and so forth.&nbsp; Is there any solution for this issue?</P> <P>User Section Access Table:</P> <TABLE style="border-collapse: collapse; width: 96pt;" border="0" width="128" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 14.5pt;"> <TD width="64" height="19" class="xl63" style="height: 14.5pt; width: 48pt;">User</TD> <TD width="64" class="xl63" style="border-left: none; width: 48pt;">Key</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" class="xl63" style="height: 14.5pt; border-top: none;">A</TD> <TD align="right" class="xl63" style="border-top: none; border-left: none;">1001</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" class="xl63" style="height: 14.5pt; border-top: none;">B</TD> <TD align="right" class="xl63" style="border-top: none; border-left: none;">1002</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" class="xl63" style="height: 14.5pt; border-top: none;">C</TD> <TD align="right" class="xl63" style="border-top: none; border-left: none;">1003</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" class="xl63" style="height: 14.5pt; border-top: none;">D</TD> <TD align="right" class="xl63" style="border-top: none; border-left: none;">1004</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" class="xl63" style="height: 14.5pt; border-top: none;">E</TD> <TD align="right" class="xl63" style="border-top: none; border-left: none;">1005</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>OR Table:</P> <TABLE style="border-collapse: collapse; width: 144pt;" border="0" width="192" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 14.5pt;"> <TD width="64" height="19" class="xl65" style="height: 14.5pt; width: 48pt;">Data ID</TD> <TD width="64" class="xl65" style="border-left: none; width: 48pt;">Key1</TD> <TD width="64" class="xl65" style="border-left: none; width: 48pt;">Key2</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" class="xl65" style="height: 14.5pt; border-top: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1001</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1006</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" class="xl65" style="height: 14.5pt; border-top: none;">2</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1001</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1002</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" class="xl65" style="height: 14.5pt; border-top: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1002</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1008</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" class="xl65" style="height: 14.5pt; border-top: none;">4</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1006</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1004</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" class="xl65" style="height: 14.5pt; border-top: none;">...</TD> <TD class="xl65" style="border-top: none; border-left: none;">…</TD> <TD class="xl65" style="border-top: none; border-left: none;">…</TD> </TR> </TBODY> </TABLE> Wed, 16 Nov 2022 01:47:03 GMT https://community.qlik.com/t5/QlikView/Section-Access-match-two-fields/m-p/2005003#M1221508 StacyCui 2022-11-16T01:47:03Z https://community.qlik.com/t5/QlikView/Section-Access-match-two-fields/m-p/2005242#M1221517 <P>Hi,</P> <P>Take a look at the attached. It should help you on this.<BR /><BR /><BR /></P> Wed, 16 Nov 2022 11:28:19 GMT https://community.qlik.com/t5/QlikView/Section-Access-match-two-fields/m-p/2005242#M1221517 Bill_Britt 2022-11-16T11:28:19Z