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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using Inputfield to add a new field

Hello to all,

I am working on a table that I loaded from Excel. I want to add a row to this table using inputfield. Can anyone tell me how to do so?


Thank you for your responses.

Labels (1)
1 Reply
Not applicable
Author

HI,

Here's my solution:

Create a straight table, add a calculated dimension with the follow expression:

=ValueList('$(=concat(if(aggr(sum(VALUE),HEAD),HEAD),chr(39)&','&chr(39)))',vNewRow)

I created this table in excel.

HEADVALUE
A100
B200