topic Re: Custom order to concatenated list in App Development

Custom order to concatenated list

egeremia — Mon, 11 Jul 2022 19:06:26 GMT

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

Re: Custom order to concatenated list

rwunderlich — Tue, 12 Jul 2022 00:13:51 GMT

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

Re: Custom order to concatenated list

egeremia — Tue, 12 Jul 2022 13:35:51 GMT

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?

Re: Custom order to concatenated list

rwunderlich — Tue, 12 Jul 2022 17:45:28 GMT

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

Re: Custom order to concatenated list

egeremia — Tue, 12 Jul 2022 18:34:19 GMT

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

Re: Custom order to concatenated list

rwunderlich — Tue, 12 Jul 2022 20:09:19 GMT

Add Quote.Description to the Aggr like this:

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

-Rob

Re: Custom order to concatenated list

egeremia — Tue, 12 Jul 2022 20:17:43 GMT

That did the trick, thank you!