Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Input fields inside table

Hello everyone,

I am loading data from QVD which contains such information:



ID

DepartmentSalary
1HR1000
2IT1200
3Finance1300
4Insurance1400
5Logistics1000

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.

IDDepartmentSalaryRatingComment1Comment2
1HR1000
2IT1200
3Finance1300
4Insurance1400
5Logistics1000

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

1 Solution

Accepted Solutions
Highlighted

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

View solution in original post

1 Reply
Highlighted

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

View solution in original post