Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

How to do insert value default in inputfield?

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.

6 Replies
Highlighted
MVP
MVP

Re: How to do insert value default in inputfield?

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

Not applicable

Re: How to do insert value default in inputfield?

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

MVP
MVP

Re: How to do insert value default in inputfield?

don't know

try in this way

- comment inputfield

- reload

- remove comment inputfield

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

Not applicable

Re: How to do insert value default in inputfield?

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

MVP
MVP

Re: How to do insert value default in inputfield?

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

1.png

Not applicable

Re: How to do insert value default in inputfield?

Is there another way to do this without using macro?