Concat sort order

[Anonymous]

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 !

[sunny_talwar]

Try this

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

[Anonymous]

Error in expression

[sunny_talwar]

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

[sunny_talwar]

This worked for me

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

[adamdavi3s]

don't think rank works in a concat?

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

[sunny_talwar]

It seems to have worked with Aggr()

[Anonymous]

I've used this

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

Still hasn't worked..

[sunny_talwar]

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

[vishsaggi]

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))