topic Re: Section Access on multiple fields in QlikView https://community.qlik.com/t5/QlikView/Section-Access-on-multiple-fields/m-p/1345112#M831905 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-blogpost/3757">Data Reduction Using Multiple Fields</A></P></BODY></HTML> Fri, 09 Jun 2017 14:25:40 GMT MK_QSL 2017-06-09T14:25:40Z Section Access on multiple fields https://community.qlik.com/t5/QlikView/Section-Access-on-multiple-fields/m-p/1345111#M831904 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to implement Section Access on multiple fields:</P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 469px;"><TBODY><TR><TD height="17" style="border: 0.5pt solid windowtext; border-image: none;" width="61"><SPAN style="color: #000000;">ACCESS</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="62"><SPAN style="color: #000000;">NTNAME</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="198"><SPAN style="color: #000000;">ORG_LEVEL_2</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="148"><SPAN style="color: #000000;">ORG_LEVEL_4</SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000;">USER</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000;">O652956</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000;">COMMERCIAL TERM LENDING</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000;"> </SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000;">USER</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000;">O652956</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000;">MMBSI</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000;"> </SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000;">USER</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000;">O652956</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000;">CCBSI</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000;">CCBSI - REAL ESTATE</SPAN></TD></TR></TBODY></TABLE><P></P><P>Now the issue I am facing is that, as soon as I put value CCBSI-Real Estate in ORG_Level_4 I am only able to see CCBSI in Org_Level2 &amp; CCBSI-Real Estate in Org_Level_4 but I want to see MMBSI &amp; Commercial Term Lending detils also.</P><P></P><P>I understand section access works on AND condition which is the reason of this output. But I am not able to find a solution. I tried a bridge table too but without success.</P><P>Please help</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Section-Access-on-multiple-fields/m-p/1345111#M831904 Anonymous 2020-11-25T16:16:04Z Re: Section Access on multiple fields https://community.qlik.com/t5/QlikView/Section-Access-on-multiple-fields/m-p/1345112#M831905 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-blogpost/3757">Data Reduction Using Multiple Fields</A></P></BODY></HTML> Fri, 09 Jun 2017 14:25:40 GMT https://community.qlik.com/t5/QlikView/Section-Access-on-multiple-fields/m-p/1345112#M831905 MK_QSL 2017-06-09T14:25:40Z Re: Section Access on multiple fields https://community.qlik.com/t5/QlikView/Section-Access-on-multiple-fields/m-p/1345113#M831906 <HTML><HEAD></HEAD><BODY><P>Hi Fayez,</P><P></P><P>look at this: <A href="https://www.youtube.com/watch?v=_5SNY_UZBtQ" title="https://www.youtube.com/watch?v=_5SNY_UZBtQ">QlikView Tutorials | Component Level Security in QlikView - YouTube</A></P><P></P><P>I hope that helps</P><P></P><P>Beck</P></BODY></HTML> Fri, 09 Jun 2017 14:53:31 GMT https://community.qlik.com/t5/QlikView/Section-Access-on-multiple-fields/m-p/1345113#M831906 beck_bakytbek 2017-06-09T14:53:31Z