How to do insert value default in inputfield?

[#1]

I would like set default value in load for inputfield, for example:

// Set up budget area for alowing data entry

INPUTFIELD Budget;

// Sample Data

LOAD * INLINE [

    Area, Actual, Budget

    North, 10000, 100

    South, 20000, 200

    East, 30000, 300

    West, 40000, 500

];

But, when i load the data, my inputfield set value 0.

[maxgro]

when you load data the first time your inputfield should get the values from inline table

the second, third, etc loads doesn't change the input field values

to change that (restore defualt = inline table values) you can

- right click on input field --> restore values

- if I'm not wrong use a macro

EDIT: here for macro

Re: Reseting an editable table to show default values again on a button click

[#3]

In my case when i load data the first time, input field set value 0 not the value the inline table. Whats wrong?

[maxgro]

don't know

try in this way

- comment inputfield

- reload

- remove comment inputfield

- reload (in my Qlik I get the default values)

[#5]

Its worked for me now! But is there a way to make restor values ​​automatically?

[maxgro]

at the sheet level (onactivatesheet event) you can run the macro

[#7]

Is there another way to do this without using macro?