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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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?

4 Replies
swuehl
MVP
MVP

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