topic QlikView Section Access for intersection in Search the Community https://community.qlik.com/t5/Search-the-Community/QlikView-Section-Access-for-intersection/m-p/1800483#M286 <P>Update QlikView code such that AD Groups assigned to different column values are granted access for the intersection of those values.<BR />For example: an individual in AD Group qlik.support would only see records where Country is Japan AND Region is North.</P><P>&nbsp;</P><P>DashboardName&nbsp; &nbsp; &nbsp; ADGroupName&nbsp; &nbsp; &nbsp; &nbsp; Country&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Region<BR />SA.qvw&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; qlik.support&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Japan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;North</P><P>So here we want see data for intersection of both Japan and North.</P> Mon, 19 Apr 2021 12:45:34 GMT nagarjuna9563 2021-04-19T12:45:34Z QlikView Section Access for intersection https://community.qlik.com/t5/Search-the-Community/QlikView-Section-Access-for-intersection/m-p/1800483#M286 <P>Update QlikView code such that AD Groups assigned to different column values are granted access for the intersection of those values.<BR />For example: an individual in AD Group qlik.support would only see records where Country is Japan AND Region is North.</P><P>&nbsp;</P><P>DashboardName&nbsp; &nbsp; &nbsp; ADGroupName&nbsp; &nbsp; &nbsp; &nbsp; Country&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Region<BR />SA.qvw&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; qlik.support&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Japan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;North</P><P>So here we want see data for intersection of both Japan and North.</P> Mon, 19 Apr 2021 12:45:34 GMT https://community.qlik.com/t5/Search-the-Community/QlikView-Section-Access-for-intersection/m-p/1800483#M286 nagarjuna9563 2021-04-19T12:45:34Z Re: QlikView Section Access for intersection https://community.qlik.com/t5/Search-the-Community/QlikView-Section-Access-for-intersection/m-p/1800489#M287 <P>Why not just combining:</P><P>Country &amp; '|' &amp; Region as CountryRegion</P><P>within the section access and in the datamodel?</P><P>- Marcus</P> Mon, 19 Apr 2021 12:57:44 GMT https://community.qlik.com/t5/Search-the-Community/QlikView-Section-Access-for-intersection/m-p/1800489#M287 marcus_sommer 2021-04-19T12:57:44Z