Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set inputfield value using macro

Hi, community.

Could you help me with the SetInputFieldValue method?

Script:

set v = ActiveDocument.Fields("MyInputField")

v.SetInputFieldValue 0, "MyValue"

it sets MyValue in first row of table. It works well.

But problem appears when I have a selection in MyInputField.

How I can set value in the first selected row?

Thanks a lot.

2 Replies
fosuzuki
Partner - Specialist III
Partner - Specialist III

Hi,

what about creating an auxiliary list box in the sheet and using:

set lb = ActiveDocument.GetSheetObject("LB01")

lb.SetInputFieldCell 0,"999"   'set first value to 999

Regards

marcelo_7
Creator
Creator

This worked for me! Thanks!