topic Re: Clear dimensions with expressions using macro in QlikView https://community.qlik.com/t5/QlikView/Clear-dimensions-with-expressions-using-macro/m-p/494179#M690061 <HTML><HEAD></HEAD><BODY><P>Nope. Unless you use ActiveDocument.ClearAll.</P></BODY></HTML> Mon, 21 Oct 2013 11:51:01 GMT Gysbert_Wassenaar 2013-10-21T11:51:01Z Clear dimensions with expressions using macro https://community.qlik.com/t5/QlikView/Clear-dimensions-with-expressions-using-macro/m-p/494178#M690060 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to create a trigger which clears data in my straight table each time a selection in my multi box is made.</P><P></P><P>I've implemented a macro with the following types of expressions:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; ActiveDocument.GetSheetObject("LB01").Clear</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ActiveDocument.GetSheetObject("CH01").ClearMemberFields</P><P></P><P>My dimensions with dates have been edited to suit a particular format, and these dimensions are the only fields which don't get cleared when using the .ClearMemberFields command.</P><P></P><P>Is there another command which clears dimensions which are expressions of the original fields?</P><P></P><P>Thanks</P></BODY></HTML> Mon, 21 Oct 2013 02:37:33 GMT https://community.qlik.com/t5/QlikView/Clear-dimensions-with-expressions-using-macro/m-p/494178#M690060 2013-10-21T02:37:33Z Re: Clear dimensions with expressions using macro https://community.qlik.com/t5/QlikView/Clear-dimensions-with-expressions-using-macro/m-p/494179#M690061 <HTML><HEAD></HEAD><BODY><P>Nope. Unless you use ActiveDocument.ClearAll.</P></BODY></HTML> Mon, 21 Oct 2013 11:51:01 GMT https://community.qlik.com/t5/QlikView/Clear-dimensions-with-expressions-using-macro/m-p/494179#M690061 Gysbert_Wassenaar 2013-10-21T11:51:01Z Re: Clear dimensions with expressions using macro https://community.qlik.com/t5/QlikView/Clear-dimensions-with-expressions-using-macro/m-p/494180#M690062 <HTML><HEAD></HEAD><BODY><P>That seemed to fix it.&nbsp; Thanks.</P></BODY></HTML> Tue, 22 Oct 2013 22:17:00 GMT https://community.qlik.com/t5/QlikView/Clear-dimensions-with-expressions-using-macro/m-p/494180#M690062 2013-10-22T22:17:00Z