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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Merge Text / Variables to a Single Row

I have a unique identifier that pulls in text / variables from a number of documents.  Right now, in the table I created, the text / variables that are associated with one unique identifier are appearing on multiple rows.  I want the text / variable associated with a unique identifier to appear on one row.  How can a merge these or keep this from happening?

Labels (1)
4 Replies
swuehl
Champion III
Champion III

Not really sure how your setting looks like, so a small sample application or some more details about your data model and your chart dimension / expressions would be helpful.

You can try using your unique identifier as dimension in a table chart and then use something like

=concat(TextField, ' ')

as expression.

Not applicable
Author

Here is a sample.  As you can see the data is on two separate rows:

Sample.jpg

Not applicable
Author

I have multiple lines.  What you suggested didn't seem to do it.  I do have a sum statement in the expressions.  this is needed to get data into the table.  Here is a picture of the table:

Sample.png

Not applicable
Author

can u upload the qvw?

Suraj