Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Inputfields and SR3

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?

1 Solution

Accepted Solutions
Not applicable
Author

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);

View solution in original post

2 Replies
erichshiino
Partner - Master
Partner - Master

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

Not applicable
Author

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);