Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
rcandeo
Creator III
Creator III

How can I make this selection using macro?

I have this expression in a macro:

ActiveDocument.GetField("Customer").Select. "29957"

But I wanna select the Customer excluded in real.

I wanna all the customers, except 29957.

Wich is the command in VBScript please?

1 Solution

Accepted Solutions
Not applicable

There are triggers for on open that you can attach a select from field. I currently use one so when the document is opened it selects the most recent date. In another I have it set to select a regional sales manager based on the current user then locks the field.

View solution in original post

5 Replies
Not applicable

After select, use .SelectExcluded

rcandeo
Creator III
Creator III
Author

not worked as it should. The result was different than select the customer and check select excluded in application.

Thanks

Not applicable

why even use macro? There is an action for Select in Field and then select excluded

rcandeo
Creator III
Creator III
Author

I´m using Macro cause I wanna an initial selection automatically

Not applicable

There are triggers for on open that you can attach a select from field. I currently use one so when the document is opened it selects the most recent date. In another I have it set to select a regional sales manager based on the current user then locks the field.