topic Re: How to do insert value default in inputfield? in QlikView

How to do insert value default in inputfield?

Wed, 28 May 2014 19:39:14 GMT

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 — Wed, 28 May 2014 19:57:03 GMT

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

Wed, 28 May 2014 20:01:38 GMT

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

maxgro — Wed, 28 May 2014 20:08:12 GMT

don't know

try in this way

- comment inputfield

- reload

- remove comment inputfield

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

Wed, 28 May 2014 20:16:26 GMT

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

maxgro — Wed, 28 May 2014 20:23:29 GMT

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

Thu, 29 May 2014 17:34:30 GMT

Is there another way to do this without using macro?