topic Re: SetInputFieldValue in QlikView

SetInputFieldValue

Tue, 30 Aug 2011 16:32:15 GMT

Hello community!

Please help find solution of the following problems:
The application uses a field of type Input FIeld.
The application logic needs to select some of these field values and assign a new value.
Assigning new values InputField should be done in a macro, which is activated by pressing a button.
Access to selected / available field values can be obtained using methods GetSelectedValues or GetPossibleValues. The new value can be assigned InputField calling method SetInputFieldValue.The method requires a parameter offset.
Is there a way to get the Offset value in a macro?

P.S. Sorry for the bad English.

Re: SetInputFieldValue

tanelry — Wed, 31 Aug 2011 09:01:23 GMT

Maybe it is easier to use SetInputFieldCell to write inputvalues into (hidden) tablebox or chart.

set table = ActiveDocument.GetSheetObject("TB01")

for RowIter = 1 to table.GetRowCount-1

'write new value into each row, second column

table.SetInputFieldCell RowIter-1, 1, "new value"

Re: SetInputFieldValue

Wed, 31 Aug 2011 10:27:06 GMT

Thank you! Your answer helped me a lot.