create a variable field value

[#1]

Hi,

I need to create a field that allow me to change its values manually from the user interface

ex:

value vaiable value new value

1 X1 1+X1

2 X2 2+X3

4 X3 4+x3

5 X4 5+X4

7 X5 7+X5

Is it possible??

Thank you!

[#2]

Can I create a variable array setting its length and all the values to zero??

[#3 · Accepted solution]

Hi,

You can create a INPUTFIELD, check your QlikView Reference Manual.

[#4]

Thanks Fernando!

[#5]

Hi,

I have created the inputfield and inicialized it with '0' values.

The problem is that every time I close the model the field has new values that I never introduced and I have to reload to solve that,

any idea?

Thanks

[#6]

Hi,

This really happens.

You can try to export to a file QVD using macro.

See this example.

sub ExportInputFields

set obj = ActiveDocument.GetSheetObject("CH234")


obj.ExportEx "D:\Desenv\Qvd\InputField.qvd", 4
msgbox("Exported Table")

end sub

[#7]

Sorry Fernando but I don't get it,

Why I have to export it to a qvd file?