Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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);
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);