https://community.qlik.com/t5/App-Development/Sort-the-numbers-in-ascending-order-in-a-variable/m-p/2154842#M93553 <P>Hi Anil Babu,</P> <P>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.</P> Tue, 19 Dec 2023 23:00:29 GMT Jeevayswaran 2023-12-19T23:00:29Z https://community.qlik.com/t5/App-Development/Sort-the-numbers-in-ascending-order-in-a-variable/m-p/2154244#M93514 <P>Hi All,</P> <P>&nbsp;</P> <P>I have a variable with list of values concatenated.</P> <P>vNum= 5,7,8,9,2,3,1</P> <P>&nbsp;</P> <P>I need to sort them and store in an another variable. How to do?</P> <P>Expected result: 1,2,3,5,7,8,9</P> Fri, 15 Nov 2024 21:10:10 GMT https://community.qlik.com/t5/App-Development/Sort-the-numbers-in-ascending-order-in-a-variable/m-p/2154244#M93514 Jeevayswaran 2024-11-15T21:10:10Z https://community.qlik.com/t5/App-Development/Sort-the-numbers-in-ascending-order-in-a-variable/m-p/2154264#M93515 <P>presummably, you are concatenating the values of some field (this is Qlik after all), you can specify the sort order in the concat function:<BR /><BR /><A href="https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StringAggregationFunctions/concat.htm#:~:text=Concat()%20is%20used%20to,expression%20evaluated%20over%20each%20dimension.&amp;text=Arguments%3A,the%20string%20to%20be%20processed" target="_blank">https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StringAggregationFunctions/concat.htm#:~:text=Concat()%20is%20used%20to,expression%20evaluated%20over%20each%20dimension.&amp;text=Arguments%3A,the%20string%20to%20be%20processed</A>.<BR /><BR /></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="edwin_0-1702921294334.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/125687i3FCDDD78956F277F/image-size/medium?v=v2&amp;px=400" role="button" title="edwin_0-1702921294334.png" alt="edwin_0-1702921294334.png" /></span></P> <P>&nbsp;</P> Mon, 18 Dec 2023 17:41:42 GMT https://community.qlik.com/t5/App-Development/Sort-the-numbers-in-ascending-order-in-a-variable/m-p/2154264#M93515 edwin 2023-12-18T17:41:42Z https://community.qlik.com/t5/App-Development/Sort-the-numbers-in-ascending-order-in-a-variable/m-p/2154277#M93518 <P>Perhaps this</P> <P><EM><STRONG>=concat( mid(vNum, ValueLoop(1, len(vNum)),1),'',mid(vNum, ValueLoop(1, len(vNum)),1))</STRONG></EM></P> Mon, 18 Dec 2023 19:08:41 GMT https://community.qlik.com/t5/App-Development/Sort-the-numbers-in-ascending-order-in-a-variable/m-p/2154277#M93518 Anil_Babu_Samineni 2023-12-18T19:08:41Z https://community.qlik.com/t5/App-Development/Sort-the-numbers-in-ascending-order-in-a-variable/m-p/2154646#M93539 <P>How this will work if i have 2 digit numbers? please share me the expression.</P> Tue, 19 Dec 2023 13:55:54 GMT https://community.qlik.com/t5/App-Development/Sort-the-numbers-in-ascending-order-in-a-variable/m-p/2154646#M93539 Jeevayswaran 2023-12-19T13:55:54Z https://community.qlik.com/t5/App-Development/Sort-the-numbers-in-ascending-order-in-a-variable/m-p/2154842#M93553 <P>Hi Anil Babu,</P> <P>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.</P> Tue, 19 Dec 2023 23:00:29 GMT https://community.qlik.com/t5/App-Development/Sort-the-numbers-in-ascending-order-in-a-variable/m-p/2154842#M93553 Jeevayswaran 2023-12-19T23:00:29Z https://community.qlik.com/t5/App-Development/Sort-the-numbers-in-ascending-order-in-a-variable/m-p/2154843#M93554 <P>Hi Edwin,</P> <P>Thanks for your reply. When I used the sort weight option, The concatenate result has duplicate values .(Sometime the same bucket appears 2 times)</P> Tue, 19 Dec 2023 23:03:26 GMT https://community.qlik.com/t5/App-Development/Sort-the-numbers-in-ascending-order-in-a-variable/m-p/2154843#M93554 Jeevayswaran 2023-12-19T23:03:26Z