topic create a variable field value in QlikView

create a variable field value

Fri, 28 Jan 2011 16:14:41 GMT

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!

Mon, 31 Jan 2011 15:45:16 GMT

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

Mon, 31 Jan 2011 16:02:39 GMT

Hi,

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

Tue, 01 Feb 2011 08:30:03 GMT

Thanks Fernando!

Wed, 16 Feb 2011 14:02:56 GMT

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

Wed, 16 Feb 2011 16:14:05 GMT

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

Wed, 16 Feb 2011 17:02:08 GMT

Sorry Fernando but I don't get it,

Why I have to export it to a qvd file?