Discussion Board for collaboration on QlikView Scripting.
Hello QV developers,
I have column of text like this:
I am trying to use CONCAT function in the script like this so that I can get all text values in one cell.
CONCAT(Col1, ';') As ConcatCol
The result looks like this:
This is not what I desire. The Text gets already sorted before the concatenation. I want the result in the same order as the rows appear in the first table like
This is what I desire
How can I achieve this? Thanks for your help.
Problem Solved. I just realized we can have sort option as the third parameter inside the CONCAT function. So I am able to use the row number as the sort order. This works now. Thanks.
View solution in original post