topic Set inputfield value using macro in QlikView

Set inputfield value using macro

Mon, 26 Mar 2012 12:13:06 GMT

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.

fosuzuki — Tue, 27 Mar 2012 22:52:35 GMT

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 — Wed, 22 Aug 2012 14:40:14 GMT

This worked for me! Thanks!