Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

hello Friends,can anyone tell me the concept of inputfields in qlikview

can anyone tell me the concept of inputfields in qlikview?

I am not getting it properly through reference mannual.

Thanks in advance

8 Replies
sushil353
Master II
Master II

when ever you make any field as inputfield in script then on the UI you can change the values for that field..

a arrow mark will me highlighted when you hover over that field cell..

basically inputfield create a special field inside qlikview and we can change value of that field.

HTH

sushil

tresesco
MVP
MVP

From help:

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.

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.

The syntax is:

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.

Examples:

Inputfield B;

Inputfield A,B;

Inputfield B??x*;

Please let know the area that is not clear to you. Have a look at the attached sample, field 'B' is defined as inputfield, hence it lets you change its values in the front end, but you can't add data because the place holder is defined in the script (i.e - no of data points).

Not applicable
Author

Thanks Tresesco,

for a helpful answer,

I want to know the practical use of it. means in which case i can use this inputfield method.

Not applicable
Author

Thanks  Shushil.

tresesco
MVP
MVP

If you can think of, there would be many scenarios. Let me explain one. Lets say, your user wants to input her own text to be displayed dynamically somewhere in the app. You might think of using variables, but if this has to have some association with other fields as well, then your task would increase maitaining multiple variables and incorporation them in the expression. However the same you can do it easily using this inputfields.

Not applicable
Author

Thanks Tresesco for explaination,

I got it..

bill_mtc
Partner - Creator
Partner - Creator

Based on my understanding as lay man's term, an inputfield is a qlikview feature which you can change your field value DYNAMICALLY, without changing the original datasource data or reloading the application. This is somehow necessary when you categorized any entity. Thanks for posting like this, I learned.

bill_mtc
Partner - Creator
Partner - Creator

I agree with you!