topic Re: How to make sheet available for specific users in QlikView https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830196#M292177 <HTML><HEAD></HEAD><BODY><P>But 'Absolutely!!' is not the right answer ! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/silly.png" /> Please mark the right one as 'Correct Answer', that would help people find it easily.</P></BODY></HTML> Fri, 26 Jun 2015 11:42:50 GMT tresB 2015-06-26T11:42:50Z How to make sheet available for specific users https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830187#M292168 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am trying to limit access of a sheet to certain users.</P><P></P><P>I tried using conditional show property of sheet, but it didn't work. Please help. </P><P></P><P>Thanks</P><P></P><P><IMG alt="abc.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/90968_abc.jpg" style="height: 348px; width: 620px;" /></P></BODY></HTML> Fri, 26 Jun 2015 10:50:46 GMT https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830187#M292168 kamal_sanguri 2015-06-26T10:50:46Z Re: How to make sheet available for specific users https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830188#M292169 <HTML><HEAD></HEAD><BODY><P>Hi Kamal,</P><P></P><P>using OSuser like that should work fine, check the case or upper everything, might just be a case sensitivity issue.</P><P></P><P>The other option you have is section access, maybe have a look here</P><P><A href="https://community.qlik.com/docs/DOC-5175">Sheets Security with Section Access</A></P><P></P><P>hope that helps</P><P>Joe</P></BODY></HTML> Fri, 26 Jun 2015 10:55:19 GMT https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830188#M292169 2015-06-26T10:55:19Z Re: How to make sheet available for specific users https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830189#M292170 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>you are correct with OS user, when you say it's not working, do you mean that the sheet is VISIBLE to all OR HIDDEN?</P><P></P><P>Andy</P><P></P><P>OSuser should be in the format DOMAIN\USER</P></BODY></HTML> Fri, 26 Jun 2015 11:03:47 GMT https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830189#M292170 awhitfield 2015-06-26T11:03:47Z Re: How to make sheet available for specific users https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830190#M292171 <HTML><HEAD></HEAD><BODY><P>I used different id's including mine.. but it is always visible..</P><P></P><P>Although, it should be visible to me only..</P></BODY></HTML> Fri, 26 Jun 2015 11:06:35 GMT https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830190#M292171 kamal_sanguri 2015-06-26T11:06:35Z Re: How to make sheet available for specific users https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830191#M292172 <HTML><HEAD></HEAD><BODY><P>Yes.. I have already checked that ..&nbsp; </P><P></P><P>I observed something strange.. When I just copied that condition in new qlikview file.. It started working as it supposed to be..</P><P></P><P>Any idea what can be the wrong with my exiting qvw.</P><P></P><P>Thanks</P></BODY></HTML> Fri, 26 Jun 2015 11:08:10 GMT https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830191#M292172 kamal_sanguri 2015-06-26T11:08:10Z Re: How to make sheet available for specific users https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830192#M292173 <HTML><HEAD></HEAD><BODY><P>try like this</P><P>=IF(OSUser()='UserName',1,0)</P></BODY></HTML> Fri, 26 Jun 2015 11:16:15 GMT https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830192#M292173 sunilkumarqv 2015-06-26T11:16:15Z Re: How to make sheet available for specific users https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830193#M292174 <HTML><HEAD></HEAD><BODY><P>Goto Settings-&gt;Document Properties-&gt;Security-&gt; Show All Sheets and Objects,&nbsp; <STRONG>un</STRONG>check it.</P></BODY></HTML> Fri, 26 Jun 2015 11:20:31 GMT https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830193#M292174 tresB 2015-06-26T11:20:31Z Re: How to make sheet available for specific users https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830194#M292175 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P>=MixMatch(</P><P>osuser(),</P><P>'user1',</P><P>'user2',</P><P>)</P><P>&gt;0</P></BODY></HTML> Fri, 26 Jun 2015 11:25:13 GMT https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830194#M292175 Anonymous 2015-06-26T11:25:13Z Re: How to make sheet available for specific users https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830195#M292176 <HTML><HEAD></HEAD><BODY><P>Absolutely..!!</P></BODY></HTML> Fri, 26 Jun 2015 11:37:40 GMT https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830195#M292176 kamal_sanguri 2015-06-26T11:37:40Z Re: How to make sheet available for specific users https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830196#M292177 <HTML><HEAD></HEAD><BODY><P>But 'Absolutely!!' is not the right answer ! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/silly.png" /> Please mark the right one as 'Correct Answer', that would help people find it easily.</P></BODY></HTML> Fri, 26 Jun 2015 11:42:50 GMT https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830196#M292177 tresB 2015-06-26T11:42:50Z Re: How to make sheet available for specific users https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830197#M292178 <HTML><HEAD></HEAD><BODY><P>ooops.. My Bad...</P></BODY></HTML> Fri, 26 Jun 2015 12:11:26 GMT https://community.qlik.com/t5/QlikView/How-to-make-sheet-available-for-specific-users/m-p/830197#M292178 kamal_sanguri 2015-06-26T12:11:26Z