Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Not applicable

concat distinct with sort weight

Hey all,

I have a problem with the sort weight in a concat distinct expression.

First I just used the expression without the sort weight:

FirstSortedValue({<filters>}Person,-Date,1) & ' (' & concat(distinct {<filters>}Country,'/') & ')'

That works fine, except that the fields are ordered by alphabetical order. But when I add a sort weight with Date (nummerical version of date) the expression ignores the distinct line in the concat.

Is this a known issue?

2 Replies
Contributor II
Contributor II


I am facing the same issue.

When using sort-weight argument DISTINCT seems to be ignored.

Did you find any solution for this?

Thank you,



I'm having this same issue. Trying to Concat the Distinct values with the order based on an Amount

Concat(DISTINCT GL_CC_CODE_src_1,';',AMT_NET_TAXREP_src_1) As GL_CC_CODE_src_3

This works fine if I leave off the sort weight i.e. AMT_NET_TAXREP_src_1 

But if I have the Sort Weight the distinct does not work.