topic Condition in Macro in QlikView https://community.qlik.com/t5/QlikView/Condition-in-Macro/m-p/469707#M699251 <HTML><HEAD></HEAD><BODY><P>hi Guys </P><P>can i write the following condition in Macro :</P><P></P><P>If there is no sheetobjects in a sheet then </P><P>------</P><P>else</P><P>------</P><P></P><P></P><P>Basically i want to check whether there is any sheet object in a particular sheet or not</P></BODY></HTML> Tue, 27 Nov 2012 11:23:39 GMT 2012-11-27T11:23:39Z Condition in Macro https://community.qlik.com/t5/QlikView/Condition-in-Macro/m-p/469707#M699251 <HTML><HEAD></HEAD><BODY><P>hi Guys </P><P>can i write the following condition in Macro :</P><P></P><P>If there is no sheetobjects in a sheet then </P><P>------</P><P>else</P><P>------</P><P></P><P></P><P>Basically i want to check whether there is any sheet object in a particular sheet or not</P></BODY></HTML> Tue, 27 Nov 2012 11:23:39 GMT https://community.qlik.com/t5/QlikView/Condition-in-Macro/m-p/469707#M699251 2012-11-27T11:23:39Z Re: Condition in Macro https://community.qlik.com/t5/QlikView/Condition-in-Macro/m-p/469708#M699252 <HTML><HEAD></HEAD><BODY><P>Why would you want to do that with macro's? They are not supported by Qlikview and it can be done with buttons aswell..</P></BODY></HTML> Tue, 27 Nov 2012 11:27:14 GMT https://community.qlik.com/t5/QlikView/Condition-in-Macro/m-p/469708#M699252 2012-11-27T11:27:14Z Re: Condition in Macro https://community.qlik.com/t5/QlikView/Condition-in-Macro/m-p/469709#M699253 <HTML><HEAD></HEAD><BODY><P>You can use NoOfSheetObjects to get the number of objects on a sheet. If it is 0 then there are no objects.</P><P></P><P>set s=ActiveDocument.Sheets("Main")</P><P>if s.NoOfSheetObjects &gt; 0 then</P><P>...do stuff</P><P>else</P><P>...do other stuff</P><P>end if</P></BODY></HTML> Tue, 27 Nov 2012 11:30:14 GMT https://community.qlik.com/t5/QlikView/Condition-in-Macro/m-p/469709#M699253 Gysbert_Wassenaar 2012-11-27T11:30:14Z Re: Condition in Macro https://community.qlik.com/t5/QlikView/Condition-in-Macro/m-p/469710#M699254 <HTML><HEAD></HEAD><BODY><P>Can You give a small Example</P></BODY></HTML> Tue, 27 Nov 2012 11:34:40 GMT https://community.qlik.com/t5/QlikView/Condition-in-Macro/m-p/469710#M699254 2012-11-27T11:34:40Z Re: Condition in Macro https://community.qlik.com/t5/QlikView/Condition-in-Macro/m-p/469711#M699255 <HTML><HEAD></HEAD><BODY><P>I can't reproduce one at the moment, but that's what Qliktech told me and why i don't use Macro's.. If your Macro doesn't work after an update you can't get support on them, while buttons should cover like 99% of the posibilities. Sorry</P></BODY></HTML> Tue, 27 Nov 2012 11:45:54 GMT https://community.qlik.com/t5/QlikView/Condition-in-Macro/m-p/469711#M699255 2012-11-27T11:45:54Z Re: Condition in Macro https://community.qlik.com/t5/QlikView/Condition-in-Macro/m-p/469712#M699256 <HTML><HEAD></HEAD><BODY><P>hey Gysbert i have similar Condition with sheets </P><P></P><P>if Sheet1 exists then </P><P></P><P>--------------------</P><P></P><P>else</P><P></P><P>-----------------</P><P></P><P>can you help</P></BODY></HTML> Tue, 27 Nov 2012 18:31:05 GMT https://community.qlik.com/t5/QlikView/Condition-in-Macro/m-p/469712#M699256 2012-11-27T18:31:05Z