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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

Labels (1)
10 Replies
sunny_talwar

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