topic Calling ActiveDocument.Fields(Field).Select Value in QlikView

Calling ActiveDocument.Fields(Field).Select Value

Tue, 20 Oct 2009 01:11:31 GMT

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

Calling ActiveDocument.Fields(Field).Select Value

Tue, 20 Oct 2009 01:24:45 GMT

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?

Calling ActiveDocument.Fields(Field).Select Value

Tue, 20 Oct 2009 01:31:42 GMT

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