topic Need Help in QlikView https://community.qlik.com/t5/QlikView/Need-Help/m-p/952635#M973923 <HTML><HEAD></HEAD><BODY><P>Hi EveryOne,</P><P></P><P>I need one help, i have 3 sheets..</P><P>i want to see all sheets(Sheet1, sheet2 and sheet3), but if anyone use this application they will see only 2 sheets(<STRONG>sheet1 and sheet2</STRONG>).</P><P></P><P>is there any solution???</P></BODY></HTML> Wed, 02 Sep 2015 01:35:32 GMT paulwalker 2015-09-02T01:35:32Z Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/952635#M973923 <HTML><HEAD></HEAD><BODY><P>Hi EveryOne,</P><P></P><P>I need one help, i have 3 sheets..</P><P>i want to see all sheets(Sheet1, sheet2 and sheet3), but if anyone use this application they will see only 2 sheets(<STRONG>sheet1 and sheet2</STRONG>).</P><P></P><P>is there any solution???</P></BODY></HTML> Wed, 02 Sep 2015 01:35:32 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/952635#M973923 paulwalker 2015-09-02T01:35:32Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/952636#M973924 <HTML><HEAD></HEAD><BODY><P>Use Sheet level access</P></BODY></HTML> Wed, 02 Sep 2015 01:37:17 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/952636#M973924 Anonymous 2015-09-02T01:37:17Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/952637#M973925 <HTML><HEAD></HEAD><BODY><P>Have a look:</P><P></P><P><A href="https://community.qlik.com/docs/DOC-4435">Sheet level access</A></P><P></P><P></P><P>Hope it helps!!</P></BODY></HTML> Wed, 02 Sep 2015 01:38:36 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/952637#M973925 Anonymous 2015-09-02T01:38:36Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/952638#M973926 <HTML><HEAD></HEAD><BODY><P>without section access.. is it possible??</P><P>using OS user like..???</P></BODY></HTML> Wed, 02 Sep 2015 02:07:06 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/952638#M973926 paulwalker 2015-09-02T02:07:06Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/952639#M973927 <HTML><HEAD></HEAD><BODY><P>Hi Paul,</P><P>As per my knowledge it won't be possible.</P><P>Thank you.</P></BODY></HTML> Wed, 02 Sep 2015 02:15:04 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/952639#M973927 qlikviewwizard 2015-09-02T02:15:04Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/952640#M973928 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><A href="https://community.qlik.com/message/549001">Selecting Groups rights based on OS name</A></P></BODY></HTML> Wed, 02 Sep 2015 02:15:30 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/952640#M973928 Anonymous 2015-09-02T02:15:30Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/952641#M973929 <HTML><HEAD></HEAD><BODY><P>Yes Possible</P><P>use QVUser() or OSUser() function</P><P></P><P>ex:</P><P><SPAN style="color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; background-color: #fefdfa;">QvUser() = 'Domain\UserName'</SPAN></P></BODY></HTML> Wed, 02 Sep 2015 05:19:07 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/952641#M973929 qlikmsg4u 2015-09-02T05:19:07Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/952642#M973930 <HTML><HEAD></HEAD><BODY><P>please can you give example</P></BODY></HTML> Wed, 02 Sep 2015 17:35:39 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/952642#M973930 paulwalker 2015-09-02T17:35:39Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/952643#M973931 <HTML><HEAD></HEAD><BODY><P>on Sheet3</P><P>replace domain\user with your user</P><P></P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/97780_1.png" style="height: 307px; width: 620px;" /></P><P></P><P><SPAN style="font-size: 13.3333px;">but this can be changed by other users (it depends on security properties)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P></BODY></HTML> Wed, 02 Sep 2015 17:54:22 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/952643#M973931 maxgro 2015-09-02T17:54:22Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/952644#M973932 <HTML><HEAD></HEAD><BODY><P>Hi EveryOne,</P><P></P><P>Suppose i have ACCESS, NTNAME some other field's</P><P>then how to give Sheet level security??</P><P></P><P>I have many number of User's, but one person want to see all sheets include sheet3 also.</P><P>how to achieve this??</P></BODY></HTML> Wed, 02 Sep 2015 18:33:26 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/952644#M973932 paulwalker 2015-09-02T18:33:26Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/952645#M973933 <HTML><HEAD></HEAD><BODY><P>hi Paul,</P><P>i found an example to dynamically hide and show sheets, have a look at the attached qvw. if that helps !</P><P></P><P>Regards</P><P>Saurabh</P></BODY></HTML> Wed, 02 Sep 2015 18:47:26 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/952645#M973933 saurabh5 2015-09-02T18:47:26Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/952646#M973934 <HTML><HEAD></HEAD><BODY><P>Suppose i have permissions</P><P>NTNAME, SH01,SH02,SH03</P><P>Domain/Test, 1,1,1</P><P>Domain/Test1,1,1,0</P><P><SPAN style="font-size: 13.3333330154419px;">Domain/Test2,1,1,0</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">Domain/Test3,1,1,0</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">Domain/Test4,1,1,0</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">Suppose i have 100 of users, should i write 100 users???</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">is there any other method??/</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">Please anyone give example..........<BR /></SPAN></P></BODY></HTML> Wed, 02 Sep 2015 19:07:13 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/952646#M973934 paulwalker 2015-09-02T19:07:13Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/952647#M973935 <HTML><HEAD></HEAD><BODY><P>I have had a request for something verify similar and was able to accomplish with condition on sheet based on OSUser</P><P>bELOW WILL ALLOW JUST USER 1 AND USER 2 ACCESS TO THE SHEET</P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">UPPER</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">OSuser</SPAN><SPAN style="font-size: 8pt;">())='DOMAIN/USER1<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">OR</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">UPPER</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">OSuser</SPAN><SPAN style="font-size: 8pt;">())='DOMAIN/USER2'</SPAN></P></BODY></HTML> Wed, 02 Sep 2015 19:17:32 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/952647#M973935 2015-09-02T19:17:32Z