Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Clear dimensions with expressions using macro

Hi,

I need to create a trigger which clears data in my straight table each time a selection in my multi box is made.

I've implemented a macro with the following types of expressions:

     ActiveDocument.GetSheetObject("LB01").Clear

     ActiveDocument.GetSheetObject("CH01").ClearMemberFields

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.

Is there another command which clears dimensions which are expressions of the original fields?

Thanks

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: Clear dimensions with expressions using macro

Nope. Unless you use ActiveDocument.ClearAll.


talk is cheap, supply exceeds demand
2 Replies
Gysbert_Wassenaar
Not applicable

Re: Clear dimensions with expressions using macro

Nope. Unless you use ActiveDocument.ClearAll.


talk is cheap, supply exceeds demand
Not applicable

Re: Clear dimensions with expressions using macro

That seemed to fix it.  Thanks.