topic Re: activate a sheet whose id is a variable in QlikView https://community.qlik.com/t5/QlikView/activate-a-sheet-whose-id-is-a-variable/m-p/339686#M125394 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Say the variable is named vSheet in the QlikView application. Then the code should look like</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13442524123905946" jivemacro_uid="_13442524123905946"><P>Set s = ActiveDocument.Variables("vSheet")</P><P>ActiveDocument.GetSheetById(s<SPAN style="font-family: 'Lucida Grande', Arial, Helvetica, sans-serif; background-color: #ffffff;">.GetContent.String</SPAN>).Activate</P></PRE><P></P><P>Hope that helps.</P><P></P><P>Miguel</P><P></P><P>EDIT: Note that you can use a direct button action instead of a macro to activate a sheet depending on the value of a variable. Better off using this instead of using macro.</P></BODY></HTML> Mon, 06 Aug 2012 11:23:48 GMT Miguel_Angel_Baeyens 2012-08-06T11:23:48Z activate a sheet whose id is a variable https://community.qlik.com/t5/QlikView/activate-a-sheet-whose-id-is-a-variable/m-p/339685#M125393 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I need to write a macro in which I want to activate sheets</P><P>I know that the syntax is as follows:</P><P>ActiveDocument.GetSheetByID("SH03").Activate</P><P></P><P>however the SH03 I have it in a variable</P><P>Please advise</P></BODY></HTML> Mon, 06 Aug 2012 11:18:04 GMT https://community.qlik.com/t5/QlikView/activate-a-sheet-whose-id-is-a-variable/m-p/339685#M125393 ali_hijazi 2012-08-06T11:18:04Z Re: activate a sheet whose id is a variable https://community.qlik.com/t5/QlikView/activate-a-sheet-whose-id-is-a-variable/m-p/339686#M125394 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Say the variable is named vSheet in the QlikView application. Then the code should look like</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13442524123905946" jivemacro_uid="_13442524123905946"><P>Set s = ActiveDocument.Variables("vSheet")</P><P>ActiveDocument.GetSheetById(s<SPAN style="font-family: 'Lucida Grande', Arial, Helvetica, sans-serif; background-color: #ffffff;">.GetContent.String</SPAN>).Activate</P></PRE><P></P><P>Hope that helps.</P><P></P><P>Miguel</P><P></P><P>EDIT: Note that you can use a direct button action instead of a macro to activate a sheet depending on the value of a variable. Better off using this instead of using macro.</P></BODY></HTML> Mon, 06 Aug 2012 11:23:48 GMT https://community.qlik.com/t5/QlikView/activate-a-sheet-whose-id-is-a-variable/m-p/339686#M125394 Miguel_Angel_Baeyens 2012-08-06T11:23:48Z