Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Data from table into text object

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

2 Replies
swuehl
Not applicable

Re: Data from table into text object

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

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

Not applicable

Re: Data from table into text object

Yes that works. Thank you.