topic concat distinct with sort weight in QlikView

concat distinct with sort weight

Mon, 22 Apr 2013 14:51:53 GMT

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?

Re: concat distinct with sort weight

PedroCunha — Mon, 25 Mar 2019 14:23:59 GMT

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

Re: concat distinct with sort weight

shane_spencer — Wed, 08 Jul 2020 12:47:38 GMT

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.