topic Re: Concat sort order in QlikView

Concat sort order

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

This is puzzling me so I hope you can help. I am trying to sort on a concat expression

Concat(distinct product_size1, ', ',product_size_alpha)

For some reason this isn't sorting by product_size_alpha though. Unless I am missing something...?!

When i try the expression above I get this output

Does the sort order within a concat expression not work when alphabetical?

Hoping someone can help because this is driving me mad !

Re: Concat sort order

sunny_talwar — Fri, 24 Mar 2017 14:42:47 GMT

Try this

Concat(distinct product_size1, ', ', Rank(product_size_alpha))

Re: Concat sort order

Anonymous — Fri, 24 Mar 2017 14:45:53 GMT

Error in expression

Re: Concat sort order

sunny_talwar — Fri, 24 Mar 2017 14:47:55 GMT

Try clicking okay to see if it gives you any output or does it just says no output displayed or something similar?

Re: Concat sort order

sunny_talwar — Fri, 24 Mar 2017 14:52:20 GMT

This worked for me

=Concat(DISTINCT Product_Size1, ', ', -Aggr(Rank(Product_Size_Alpha), Product_Size1))

Re: Concat sort order

adamdavi3s — Fri, 24 Mar 2017 14:55:16 GMT

don't think rank works in a concat?

Maybe use Dual or lob a pick(match()) in there?

Re: Concat sort order

sunny_talwar — Fri, 24 Mar 2017 14:55:55 GMT

It seems to have worked with Aggr()

Re: Concat sort order

Anonymous — Fri, 24 Mar 2017 15:27:09 GMT

I've used this

=Concat(DISTINCT product_size1, ', ', -Aggr(Rank(product_size_alpha), product_size1))

Still hasn't worked..

Re: Concat sort order

sunny_talwar — Fri, 24 Mar 2017 15:31:16 GMT

Would you be able to share a sample where this hasn't worked? Or look at what I attached and see what the difference is between what I posted and what you have

Re: Concat sort order

vishsaggi — Fri, 24 Mar 2017 15:35:46 GMT

Extending Sunny's expr: Try like: Are you trying to aggr based on your Product_Size_Alpha right ?

=Concat(DISTINCT product_size1, ', ', -Aggr(Rank(product_size_alpha), product_size_alpha))

Re: Concat sort order

sasiparupudi1 — Sat, 25 Mar 2017 18:22:19 GMT

Try

Concat(Product_Size1,',',Ord(Product_Size_Alpha))