Input fields inside table

[summerrain]

Hello everyone,

I am loading data from QVD which contains such information:

ID	Department	Salary
1	HR	1000
2	IT	1200
3	Finance	1300
4	Insurance	1400
5	Logistics	1000

In QlikView dashboard I'd like to have such table which has the same data as in QVD but with additional 3 fields - Rating, Comment1, Comment2 which all would be  input fields (without any values at first). Rating would accept numeric values and comment1 and comment2 would accept text string.

ID	Department	Salary	Rating	Comment1	Comment2
1	HR	1000
2	IT	1200
3	Finance	1300
4	Insurance	1400
5	Logistics	1000

Is this possible to achieve? Any ideas how to do this? Thank you!

[sunny_talwar · Accepted solution]

Making them inputfield is possible, but assigning a particular type of data isn't possible because there is no way to assign this

You can do something like this to make them imputfields:

INPUTFIELD Rating;

INPUTFIELD Comment1;

INPUTFIELD Comment2;

TableName:

LOAD ID,

          Department,

          Salary,

          '' as Rating,

          '' as Comment1,

          '' as Comment2

FROM YourQVDFile.qvd (qvd);