topic Using an Admin Lookup to control access in QlikView https://community.qlik.com/t5/QlikView/Using-an-Admin-Lookup-to-control-access/m-p/1424420#M429210 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a lookup of names :</P><P></P><P>OSUSER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADMIN_LEVEL</P><P>ThisDomain\User1&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P><SPAN style="font-size: 13.3333px;">ThisDomain\User2&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN></P><P><SPAN style="font-size: 13.3333px;">ThisDomain\User3&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</SPAN></P><P></P><P></P><P>Is there a way of hiding a tab or a button to all those users who are level 2?</P><P></P><P>Thanks</P><P></P><P>Phil</P></BODY></HTML> Fri, 15 Sep 2017 09:22:44 GMT prees959 2017-09-15T09:22:44Z Using an Admin Lookup to control access https://community.qlik.com/t5/QlikView/Using-an-Admin-Lookup-to-control-access/m-p/1424420#M429210 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a lookup of names :</P><P></P><P>OSUSER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADMIN_LEVEL</P><P>ThisDomain\User1&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P><SPAN style="font-size: 13.3333px;">ThisDomain\User2&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN></P><P><SPAN style="font-size: 13.3333px;">ThisDomain\User3&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</SPAN></P><P></P><P></P><P>Is there a way of hiding a tab or a button to all those users who are level 2?</P><P></P><P>Thanks</P><P></P><P>Phil</P></BODY></HTML> Fri, 15 Sep 2017 09:22:44 GMT https://community.qlik.com/t5/QlikView/Using-an-Admin-Lookup-to-control-access/m-p/1424420#M429210 prees959 2017-09-15T09:22:44Z Re: Using an Admin Lookup to control access https://community.qlik.com/t5/QlikView/Using-an-Admin-Lookup-to-control-access/m-p/1424421#M429211 <HTML><HEAD></HEAD><BODY><P>Yes, and the most straightforward implementation comes with Section Access.</P><P></P><P>See for example here:<A href="https://community.qlik.com/docs/DOC-5175">Sheets Security with Section Access</A></P><P></P><P>The article contains a link to another post that does the same thing using MATCH() calls. That may be simpeler to use if you don't need strictly controlled access or data reduction. </P></BODY></HTML> Fri, 15 Sep 2017 11:05:30 GMT https://community.qlik.com/t5/QlikView/Using-an-Admin-Lookup-to-control-access/m-p/1424421#M429211 Peter_Cammaert 2017-09-15T11:05:30Z