topic Sheet Macros in QlikView https://community.qlik.com/t5/QlikView/Sheet-Macros/m-p/254497#M1206358 <HTML><HEAD></HEAD><BODY><P>That works! Thank you!!!</P></BODY></HTML> Thu, 29 Apr 2010 20:52:26 GMT 2010-04-29T20:52:26Z Sheet Macros https://community.qlik.com/t5/QlikView/Sheet-Macros/m-p/254495#M1206356 <HTML><HEAD></HEAD><BODY><P>I'm trying to set a macro so that when opening a sheet two options from the "Cateogory" field are selected. I'm not sure about the QlikView script to do so. Below is an example that I've tried that does not work. Any help is very much appreciated!</P><P></P><P></P><P></P><P></P><BR /><BR /> <P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><BR /><BR /> <P></P><P></P><P style="font-weight: bold"></P><P style="font-weight: bold">Sub</P><B></B><P style="font-weight: bold"></P>SetPain_Communication<BR /><BR /> <P></P><P></P><P></P><P></P><P></P><P></P><P></P><BR /><BR /> <BR /><BR /> <P></P><P>ActiveDocument.Fields("Category").Select("Pain")</P><P>AND</P><P>ActiveDocument.Fields("Category").Select("Communication")</P><BR /><BR /> <P></P><P></P><P></P><P></P><P></P><BR /><BR /> <B>end</B><B>sub</B> <P></P><P></P><BR /><BR /> <P></P><P></P><P></P><P></P><P></P><P></P><BR /><BR /></BODY></HTML> Thu, 29 Apr 2010 17:30:39 GMT https://community.qlik.com/t5/QlikView/Sheet-Macros/m-p/254495#M1206356 2010-04-29T17:30:39Z Sheet Macros https://community.qlik.com/t5/QlikView/Sheet-Macros/m-p/254496#M1206357 <HTML><HEAD></HEAD><BODY><P>Is your macro triggering properly, but only leaving you with Communication selected? The Select function makes the value passed the one and only selection when used.</P><P>You need:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">ActiveDocument.Fields("Category").Select("Pain")<BR />ActiveDocument.Fields("Category").ToggleSelect("Communication")</PRE></BLOCKQUOTE><BR /><BR /> <P>That should make Pain the only selected value and then also select Communication. You are left with both Pain and Communication selected.</P></BODY></HTML> Thu, 29 Apr 2010 20:08:44 GMT https://community.qlik.com/t5/QlikView/Sheet-Macros/m-p/254496#M1206357 2010-04-29T20:08:44Z Sheet Macros https://community.qlik.com/t5/QlikView/Sheet-Macros/m-p/254497#M1206358 <HTML><HEAD></HEAD><BODY><P>That works! Thank you!!!</P></BODY></HTML> Thu, 29 Apr 2010 20:52:26 GMT https://community.qlik.com/t5/QlikView/Sheet-Macros/m-p/254497#M1206358 2010-04-29T20:52:26Z