Inputfield as a String

[#1]

Hi,

For few days I have been strugling with some app.

I founded out how to add an input fields to chart(straight table) and make them editable.

I simply load the input field like this:

INPUTFIELD inpFld1;

load

RowNo() AS inpFld1,

then get the values in expresion:

=InputSum(inpFld1)

And with that i can edit the field but can input only numeric values. But i need to be able to enter string values. This has to be done via some calcualtions in macro.

I can now change the field with this macro:

set obj = ActiveDocument.GetSheetObject("CH07")

obj.SetInputFieldCell 2,8,"999"

Is there a way i could write A instead of 999

[richard_pearce6 · Accepted solution]

Hi Julius,

Unfortunatly you can't use inputsum to write a text value to an inputfield.

This document may help you use a Macro to update the inputfield with a text value.

http://community.qlik.com/docs/DOC-6200

Regards

Richard