topic Data from table into text object in QlikView

Data from table into text object

Fri, 29 Jun 2012 10:49:16 GMT

Hi all,

Trying to place some text into from a table into a text object. I need all text (from 2 fields) from the table in the text object.

Something like

= field1 & ' ' & field2

But I need all text not just based on a selection. So something like:

= {1} field1 & ' ' & {1} field2

But I am getting errors.

Any ideas?

Regards

Revlin

swuehl — Fri, 29 Jun 2012 10:55:43 GMT

You'll need an aggregation function here, like concat:

=concat( {1} field1 & ' ' & field2, ', ')

Fri, 29 Jun 2012 11:35:49 GMT

Yes that works. Thank you.