Macro in VBA to select values from a list box expression

Sat, 13 Dec 2014 07:34:12 GMT

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

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 ?

topic Macro in VBA to select values from a list box expression in QlikView

Macro in VBA to select values from a list box expression