topic Open Qlikview different sheets depending on user in QlikView https://community.qlik.com/t5/QlikView/Open-Qlikview-different-sheets-depending-on-user/m-p/1370993#M419050 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I want to know wheter it is possible to have a qlikview cloud open on a certain sheet depending on the user who opens the qlikview cloud</P><P></P><P>I have two users 'TSC' and 'RS'</P><P></P><P>1) Upper(OSUser())='TSC'</P><P>2) Upper(OSUser())='RS' </P><P></P><P>When TSC opens my Qlikview cloud i want that Qlikview opens on the sheet 'Retail'.</P><P>When RS opens my Qlikview cloud I want that Qlikview opens on the sheet 'Sales'</P><P></P><P>Yet both have to be able to see both sheets.</P></BODY></HTML> Fri, 05 May 2017 09:09:13 GMT 2017-05-05T09:09:13Z Open Qlikview different sheets depending on user https://community.qlik.com/t5/QlikView/Open-Qlikview-different-sheets-depending-on-user/m-p/1370993#M419050 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I want to know wheter it is possible to have a qlikview cloud open on a certain sheet depending on the user who opens the qlikview cloud</P><P></P><P>I have two users 'TSC' and 'RS'</P><P></P><P>1) Upper(OSUser())='TSC'</P><P>2) Upper(OSUser())='RS' </P><P></P><P>When TSC opens my Qlikview cloud i want that Qlikview opens on the sheet 'Retail'.</P><P>When RS opens my Qlikview cloud I want that Qlikview opens on the sheet 'Sales'</P><P></P><P>Yet both have to be able to see both sheets.</P></BODY></HTML> Fri, 05 May 2017 09:09:13 GMT https://community.qlik.com/t5/QlikView/Open-Qlikview-different-sheets-depending-on-user/m-p/1370993#M419050 2017-05-05T09:09:13Z Re: Open Qlikview different sheets depending on user https://community.qlik.com/t5/QlikView/Open-Qlikview-different-sheets-depending-on-user/m-p/1370994#M419051 <HTML><HEAD></HEAD><BODY><P>Hi Tim,</P><P></P><P>I would suggest using a document action to activate the correct sheet.</P><P></P><UL><LI>Open document properties (Settings -&gt; Document Properties)</LI><LI>Open tab Triggers</LI><LI>Choose OnOpen in Document Event Triggers</LI><LI>Choose Add Actions (or Edit Action(s) if you've already got actions defined)</LI><LI>Select Add</LI><LI>Under Layout, choose Activate sheet</LI><LI>For Sheet ID, enter =If(Upper(OSUser())='TSC', 'Retail', 'RS')</LI></UL><P></P><P>Check that the sheet ID's (not the names) are to be used here.</P><P><IMG alt="OpenSheetForUser.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/162316_OpenSheetForUser.png" style="height: 586px; width: 620px;" /></P><P>Hope this helps you.</P><P></P><P>Kind regards,</P><P>Ronald</P></BODY></HTML> Fri, 05 May 2017 09:50:10 GMT https://community.qlik.com/t5/QlikView/Open-Qlikview-different-sheets-depending-on-user/m-p/1370994#M419051 RonaldDoes 2017-05-05T09:50:10Z Re: Open Qlikview different sheets depending on user https://community.qlik.com/t5/QlikView/Open-Qlikview-different-sheets-depending-on-user/m-p/1370995#M419052 <HTML><HEAD></HEAD><BODY><P>you may put this as trigger in Document Properties -&gt; Triggers -&gt; Document Event Triggers -&gt; On Open.</P><P></P><P>Peter</P></BODY></HTML> Fri, 05 May 2017 10:41:31 GMT https://community.qlik.com/t5/QlikView/Open-Qlikview-different-sheets-depending-on-user/m-p/1370995#M419052 prieper 2017-05-05T10:41:31Z Re: Open Qlikview different sheets depending on user https://community.qlik.com/t5/QlikView/Open-Qlikview-different-sheets-depending-on-user/m-p/1370996#M419053 <HTML><HEAD></HEAD><BODY><P>On Open -&gt; Activate Sheet:</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/162333_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Fri, 05 May 2017 10:46:41 GMT https://community.qlik.com/t5/QlikView/Open-Qlikview-different-sheets-depending-on-user/m-p/1370996#M419053 tresB 2017-05-05T10:46:41Z