Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
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
PedroCunha
Contributor II
Contributor II

Hello,

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,

Pedro

shane_spencer
Specialist
Specialist

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.