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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to deselect values in automation

I'm wanting to switch off any selections from a multibox that might have been made, so that a generated XL report gives a full tally.

I tried these and none worked:

ActiveDocument.Fields("DirectShip").Clear  (wanted to clear a specific selection)

--------

ActiveDocument.Fields("Part Classification").Clear  (wanted to clear a whole multibox)

--------

Set SelectField = ActiveDocument.Fields("Part Classification", "SD Coverage")  ("Part Classification" is name of multibox, "SD Coverage" is name of sheet/tab)
SelectField.SelectValues = SelectField.GetNoValues

Any suggestions

0 Replies