Skip to main content

Inputfield

A field may be flagged as an input field by listing it in an inputfield statement before it is referenced in any LOAD or SELECT statements.

Information noteKey fields cannot be flagged as input fields.

inputfield fieldlist

fieldlist is a comma separated list of the fields that should be flagged as input fields. The wildcard characters * and ? are allowed in field names. Quoting of field names may be necessary when wildcards are used.

Input fields behave somewhat differently from regular fields. The most important difference is their ability to accept changes in field values, interactively or programmatically, without running the script. Field values must be loaded into the field via LOAD or SELECT statements. Each field value loaded in the script will create a placeholder for a field value replacement value. Only existing field values can thus be changed interactively or programmatically. The replacement value is user dependent, i.e. when an input field is used on a server, different users will see different sets of input field values. In input fields all field values will be treated as distinct, regardless if several have the same value. Input fields normally retain their previously set value after a reload.

Example 1:  

Inputfield B;

Inputfield A,B;

Inputfield B??x*;

Example 2:  

Inputfield I;Load RecNo() as I, RecNo() as K autogenerate 10;

Information noteThe values in K need to be unique to allow I to be an input field.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com