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

Macro in VBA to select values from a list box expression

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 ?

0 Replies