Sort the numbers in ascending order in a variable

[Jeevayswaran]

Hi All,

I have a variable with list of values concatenated.

vNum= 5,7,8,9,2,3,1

I need to sort them and store in an another variable. How to do?

Expected result: 1,2,3,5,7,8,9

[edwin]

presummably, you are concatenating the values of some field (this is Qlik after all), you can specify the sort order in the concat function:

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/ChartFunctions/St....

[Anil_Babu_Samineni · Accepted solution]

Perhaps this

=concat( mid(vNum, ValueLoop(1, len(vNum)),1),'',mid(vNum, ValueLoop(1, len(vNum)),1))

[Jeevayswaran]

How this will work if i have 2 digit numbers? please share me the expression.

[Jeevayswaran]

Hi Anil Babu,

I used your concept and used the subfield function to split the values. It worked for me to order more than 1 digit numbers. Thanks a lot.

[Jeevayswaran]

Hi Edwin,

Thanks for your reply. When I used the sort weight option, The concatenate result has duplicate values .(Sometime the same bucket appears 2 times)