Custom order to concatenated list

[egeremia]

I am trying to create a table like you see here:

Except we want to order the concatenated list by the # of QuoteID's for each state (Highest # first) and not like it is (alphabetically). Here is the table with the states not concatenated and you will see the # of QuoteID's for each Description + State:

So for Accountant /  Bookkeeper the order would be VT, ME, NH, NY, CT, RI, MA

[rwunderlich]

I think it would be:

Concat(DISTINCT Quote.State, ',', -Aggr(NODISTINCT Count(DISTINCT QuoteID), Quote.State))

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

[egeremia]

Thank you for your response! This helped but only when one Quote.Description is selected. When the whole table is shown, the order is all jumbled:

Anyway for this to be consistent? 

[rwunderlich]

The heading on your second column looks funny. Is that the expression you are using or something you hardcoded in the Label? Can you show the exact expression you are using in the Measure?

-Rob

[egeremia]

Sorry yes it was hardcoded and left accidently but the expression is the one you provided

[rwunderlich · Accepted solution]

Add Quote.Description to the Aggr like this:

Concat(DISTINCT Quote.State, ',', -Aggr(NODISTINCT Count(DISTINCT QuoteID), Quote.State, Quote.Description))

-Rob

[egeremia]

That did the trick, thank you!