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: 
kdmarkee
Specialist
Specialist

Concat values of a field, twice, in calculated dimension

I'm looking for some help with the Concat() function in a straight chart.  I am trying to build a calculated dimension using the Concat() function where I assemble 2 Concat() statements in my calculated dimension, but I can't seem to get it to sort the way I want.  I'm hoping what I want to do is possible in QlikView.  Please see the attached qvw.   Thanks.

12 Replies
Anonymous
Not applicable

Per Qlikview Help:

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

Returns the aggregated string concatenation of all values of expression iterated over the chart dimension(s). Each value may be separated by the string found in delimiter. The order of concatenation may be determined by sort-weight. Sort-weight should return a numeric value where the lowest value will render the item to be sorted first.

kdmarkee
Specialist
Specialist
Author

Ah, thanks for pointing that out...I missed it in the documentation.

sunny_talwar

as this is the code that works in her qvw:

You mean his, right?