topic Inputfields and SR3 in QlikView

Inputfields and SR3

Wed, 10 Aug 2011 14:40:13 GMT

SR3 changed the way inputfields work. I just reloaded a v9 inputfields example from Qlikview in v10 SR3 and the functionality was lost. I'm confused on how to achieve the same functionality. I posed this question at the bottom of my earlier post here: http://community.qlik.com/message/131512

To add an inputfield to a table, you used to be able to declare a field an inputfield near the top of the script then do Load *, [InputField] Resident TableName. Not so anymore. What is the new best practice here?

Inputfields and SR3

erichshiino — Sun, 14 Aug 2011 15:10:38 GMT

Hi, Shanrahan

We discussed some cases in this thread, please check if it can help, if please describe you problem a bit more or post your script.

http://community.qlik.com/message/140787#140787

Regards,

Erich

Inputfields and SR3

Mon, 15 Aug 2011 18:36:05 GMT

It appears that the new best practice is a workaround where you must load from a different data source, like a qvd, rather than do a resident load. So when you are at the point where you would like to add an inputfield to your table, store the table in a QVD, then load that QVD with the additional inputfield. For example, something like:

INPUTFIELD FieldName;

Data:

LOAD * INLINE [

Name, Group

Adam, X

Andrew, X

Amy, Y

];

STORE Data into Data.qvd;

drop table Data;

LOAD *, '' AS FieldName

FROM Data.qvd(qvd);