Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

CONCAT function sort issue

Hello QV developers,

I have column of text like this:

Col1
Text10
Text17
Text3
Text4
Text5
Text6
Text7
Text8
Text1
Text2
Text11
Text12
Text13
Text14
Text15
Text16
Text45
Text24
Text21
Text76
Text18

I am trying to use CONCAT function in the script like this so that I can get all text values in one cell.

LOAD

CONCAT(Col1, ';') As ConcatCol

RESIDENT

Test1

The result looks like this:

ConcatCol
Text1;Text10;Text11;Text12;Text13;Text14;Text15;Text16;Text17;Text17;Text18;Text2;Text21;Text24;Text3;Text4;Text45;Text5;Text6;Text7;Text76;Text8

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

Text10;Text17;Text3;Text4 ...

How can I achieve this? Thanks for your help.

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: CONCAT function sort issue

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.

1 Reply
Not applicable

Re: CONCAT function sort issue

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.

Community Browser