topic Re: Macro for activating sheet in QlikView https://community.qlik.com/t5/QlikView/Macro-for-activating-sheet/m-p/337676#M124547 <HTML><HEAD></HEAD><BODY><P>HI Dave,</P><P></P><P>Thanks a lot it worked...</P></BODY></HTML> Fri, 06 Jul 2012 11:15:08 GMT Anonymous 2012-07-06T11:15:08Z Macro for activating sheet https://community.qlik.com/t5/QlikView/Macro-for-activating-sheet/m-p/337674#M124545 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a list box , if i select a value in list box sheet has to be activated.</P><P></P><P>Example: i have list box and 3 sheets</P><P></P><P>List Box</P><P></P><P>Income</P><P>Loss</P><P>Margin</P><P></P><P>If i select loss , loss sheet has to be activated and curren sheet has to be de activated.</P><P></P><P>Thanks in advance</P></BODY></HTML> Fri, 06 Jul 2012 10:50:57 GMT https://community.qlik.com/t5/QlikView/Macro-for-activating-sheet/m-p/337674#M124545 Anonymous 2012-07-06T10:50:57Z Re: Macro for activating sheet https://community.qlik.com/t5/QlikView/Macro-for-activating-sheet/m-p/337675#M124546 <HTML><HEAD></HEAD><BODY><P>Change the list box to "Always one selected value" on the general tab. You have to select a value first.</P><P></P><P>Change the sheet (eg. Income) from always show to conditional, with the condition like:</P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #ffffff;">GetFieldSelections(FieldName)='Income'</SPAN></P><P></P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #ffffff;">Repeat with the other sheets.<BR /></SPAN></P></BODY></HTML> Fri, 06 Jul 2012 11:02:22 GMT https://community.qlik.com/t5/QlikView/Macro-for-activating-sheet/m-p/337675#M124546 2012-07-06T11:02:22Z Re: Macro for activating sheet https://community.qlik.com/t5/QlikView/Macro-for-activating-sheet/m-p/337676#M124547 <HTML><HEAD></HEAD><BODY><P>HI Dave,</P><P></P><P>Thanks a lot it worked...</P></BODY></HTML> Fri, 06 Jul 2012 11:15:08 GMT https://community.qlik.com/t5/QlikView/Macro-for-activating-sheet/m-p/337676#M124547 Anonymous 2012-07-06T11:15:08Z