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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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