Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vlad_komarov
Partner - Specialist III
Partner - Specialist III

Updating field names in MultiBox using Macro

Hello,

I need to populate a MultiBox dynamically and update field names per pre-defined list.

Any suggestions how to do it efficiently?

Here is the sample macro:

set MB = ActiveDocument.GetSheetObject("MB01")

MB.AddField "mpt_id"

MB.AddField "Project_Full_ELT"

mbp = MB.GetProperties

mbp.MemberAttributes.Item(0).Label.v = "Project ID"

mbp.MemberAttributes.Item(0).SortCriteria.SortByState = true

mbp.MemberAttributes.Item(1).Label.v = "Project ELT"

mbp.MemberAttributes.Item(1).SortCriteria.SortByState = true

MB.SetProperties mbp

Is it possible to have table (similar to Mapping table approach) that I can use to AddFields and UpdateFieldLabels dynamically instead of "Hard-coded" version above?  

I would appreciate any suggestions.

Best regards,

Vladimir

0 Replies