Discussion board where members can get started with QlikView.
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 startA 2 beginA 3 blahblahblahB 1 startB 2 end
So for example, if I select AI want it to show in a text box formatted as:start
while if i select B:
Any method would be awesome.
Is there anything i can do maybe even in the script so i can only get
A start (newline) begin (newline) blahblahbalhB start(newline) end(newline)
If the line field determines the order: concat(distinct [Text], chr(10), line)
View solution in original post
Try concat(distinct [Text], chr(10))
it doesn't seem to be in order