Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Can Concat function take 'Load Order' as an argument?

Hi,

my function is as follows:

=Concat(DISTINCT Month, ', ')


Be default the result is sorted in an alphabetic order - from A to Z.


I'd like to sort it by load order, so that Jan should come first.


I've found out the general description. It is possible to add a sort_weight.

concat([{set_expression}] [ distinct ] [ total [<fld {, fld}>]] expression[, delimiter[, sort_weight]])


But how exactly can define that sort_weight should equal load order?

Thank you in advance,


Larisa

10 Replies
sunny_talwar

Yup, I forgot to put the single quotes around it. Glad you caught my error