How to sort in CONCAT?

[dwighttrumbower]

I'm using

=CONCAT(distinct Year, ' |'  )

[Saravanan_Desingh]

Use the third argument (sort-weight) to sort.

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/StringA...

[dwighttrumbower]

I have tried but get it to order by descending year. Not sure I understand sort-weight.

[Alfons_S]

Try this:

=CONCAT(distinct Year, ' |'  ,-Year)

[fernandolordao]

Did sort-weight parameter work with negative values?