topic Re: Merge Text / Variables to a Single Row in QlikView

Merge Text / Variables to a Single Row

Tue, 08 Apr 2014 22:25:16 GMT

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?

Re: Merge Text / Variables to a Single Row

swuehl — Tue, 08 Apr 2014 22:41:55 GMT

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.

Re: Merge Text / Variables to a Single Row

Tue, 08 Apr 2014 23:06:52 GMT

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

Re: Merge Text / Variables to a Single Row

Tue, 08 Apr 2014 23:16:21 GMT

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:

Re: Merge Text / Variables to a Single Row

Wed, 09 Apr 2014 00:49:27 GMT

can u upload the qvw?

Suraj