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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calling ActiveDocument.Fields(Field).Select Value

Hi,

I have created small VBS application wich calls QV method QVDoc.Fields(MyField).Select(MyValue). If the value MyValue exists, function works great, but if MyValue doesn't exists, this function returns all values. As I undrestand, this function is working same way as selection in QV: if the value doesn't exists, QV just ignores selection and select all values.

I would like to use this function, but if values doesn't exists, QV should return empty array of values, ie empty QV document. Does anybody knowns how to workaround this?

Thanks,
Ramunas

2 Replies
Not applicable
Author

I don't understand, you want to do a Clear() if search string is not found but you don't want all values to be selected?

Not applicable
Author

Sorry, If search string is not found I would like to Empty document.