Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can anyone tell me the concept of inputfields in qlikview?
I am not getting it properly through reference mannual.
Thanks in advance
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
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 valuesIn 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).
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.
Thanks Shushil.
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.
Thanks Tresesco for explaination,
I got it..
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.
I agree with you!