Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

concatenate all fields in a given column

I'm trying to display the procedure source code from a database.
The problem I'm having is that the database is giving me the source code line by line.
So I currently have something like this..

Name      line     text

A            1         start
A            2         begin
A            3         blahblahblah
B            1         start
B            2         end

So for example, if I select A
I want it to show in a text box formatted as:
start

begin
blahblahblah

while if i select B:

start

end


Any method would be awesome.

Is there anything i can do maybe even in the script so i can only get

Name        Text

A               start (newline) begin (newline) blahblahbalh
B               start(newline) end(newline)

Thanks!

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

If the line field determines the order: concat(distinct [Text], chr(10), line)


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Try concat(distinct [Text], chr(10))


talk is cheap, supply exceeds demand
Highlighted
Not applicable

it doesn't seem to be in order

Highlighted
MVP & Luminary
MVP & Luminary

If the line field determines the order: concat(distinct [Text], chr(10), line)


talk is cheap, supply exceeds demand

View solution in original post