Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to use a macro to conditionally exclude values in a list box.
I can successfully select and deselect items using ToggleSelect, but this method does not allow me to explicitly exlude values. Is a method available to explicitly exclude values from a list box?
Here's a sample code fragment:
'Get the selected values from the target field.
Set qvValues = qvField2.GetSelectedValues(pintLimit, True)
'Check whether any values have been explicitly selected in the target field.
If qvValues.Count = 0 Then
'Get the array of possible values from the target field.
Set qvValues = qvField2.GetPossibleValues(, True)
'Loop through the values of the target field.
For intCount = 0 To qvValues.Count - 1
'Exclude the current item in the target field. (This method leaves the values in a "possible" selection state and does not exclude them.)
qvField2.ToggleSelect qvValues(intCount).Text, True, 1
Next
End If
Does anyone know how to solve this particular problem?
Hi,
I am trying to make a a selection from a list box which has an expression in it.
I generally use the below syntax to select values from list box:-
listbox3=Array("<value>")
Set Qv = CreateObject("QlikTech.QlikView")
Set QvDoc = Qv.OpenDoc("<QV_File_location>")
QvDoc.GetSheetObject("<objectID")
Set fz = QvDoc.Fields("objectname")
for each v in listbox3
fz.ToggleSelect v
next
But whenever I try to access an expression from a list box, it will have an objectID but wont have an object name ? How can I solve for this problem ?