Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Sept. 16, Qlik Product Portfolio Strategy and Roadmap for Data Integration 11 AM ET REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

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
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

it doesn't seem to be in order

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post