Expression for responsive table title

[Breezy]

I created a table. I have an issue with the table title. There are ten options in my dropdown menu. When I click an individual option (such as Region 5) my table title correctly changes to read: "Region 5". If I click "Region 4" and "Region 7" from the dropdown menu,  I will have "Region 4, Region 7". If I do not click any of the options the title defaults to "National". However, every time I include "Region 10" in the title, it appears first, "Region 10, Region 4, Region 5." It should read in proper order, "Region 4, Region 5, Region 10." How do I place the 10 at the end in the title?

Here is my expression:

=if(Count(GetCurrentSelections()) > 0, Concat(Distinct Region, ', '), 'National')

[rwunderlich · Accepted solution]

The Concat() function take an optional third parameter, "sort-weight", a field used to control sorting.  You can generate an additional field to use as the sort-weight like this:

RegionSort:
LOAD
'Region ' & RecNo() as Region,
RecNo() as RegionSort
AutoGenerate 10
; 

And then your Concat is:

Concat(Distinct Region, ', ', RegionSort)

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[Breezy]

Wow! That did the trick! Thanks so much Rob! 🙂