Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

SetInputFieldValue

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.

1 Solution

Accepted Solutions
tanelry
Contributor II

Re: SetInputFieldValue

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"

  next

2 Replies
tanelry
Contributor II

Re: SetInputFieldValue

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"

  next

Not applicable

Re: SetInputFieldValue

Thank you! Your answer helped me a lot.

Community Browser