Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to inverse selection with macro ?

Hello,

i would like to export data from a table that based on an selection over few fields, but i dont know which values the user has taken.

I need to invert the selection to get the opposit of the values for further processing.

Is it possible to invert the selection with an macro, if i dont know which selection is currently active ?

Best regards,

Manic.

1 Solution

Accepted Solutions
isaiah82
Creator III
Creator III

For a specific field you can use the following to "select excluded":


ActiveDocument.Fields("FieldName").SelectExcluded

Although I'm not sure that is what you're looking for.  You can also check out: ActiveDocument.GetCurrentSelections.

View solution in original post

2 Replies
isaiah82
Creator III
Creator III

For a specific field you can use the following to "select excluded":


ActiveDocument.Fields("FieldName").SelectExcluded

Although I'm not sure that is what you're looking for.  You can also check out: ActiveDocument.GetCurrentSelections.

Not applicable
Author

Thank you, Isaiah!

That is exactly what i was searching for!

Greetings,

Manic.