https://community.qlik.com/t5/QlikView/Concat-DISTINCT-with-sort-weight/m-p/1727625#M455508 <P>Is there a way to do the same in the script?</P> Tue, 14 Jul 2020 10:48:21 GMT shane_spencer 2020-07-14T10:48:21Z https://community.qlik.com/t5/QlikView/Concat-DISTINCT-with-sort-weight/m-p/1727593#M455505 <P>I need help with of Concat Discinct of a Field with a Sort-Weight?</P><P>The default is A-Z.</P><P>i.e.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="shane_spencer_0-1594718479940.jpeg" style="width: 605px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/37395i6F0DB0A3FC33C4D5/image-dimensions/605x35?v=v2" width="605" height="35" role="button" title="shane_spencer_0-1594718479940.jpeg" alt="shane_spencer_0-1594718479940.jpeg" /></span></P><P>What I want is to sort by Total Absolute amount</P><P>i.e. The sort order should be as per below</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="shane_spencer_1-1594718479944.jpeg" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/37396i9062E7A2A28EBF63/image-size/medium?v=v2&amp;px=400" role="button" title="shane_spencer_1-1594718479944.jpeg" alt="shane_spencer_1-1594718479944.jpeg" /></span></P><P>But the best I can get is sorted by individual Absolute Amount – so it’s not distinct, values are repeated</P><P>i.e.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="shane_spencer_2-1594718479948.jpeg" style="width: 677px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/37397i583D064910A3DBCD/image-dimensions/677x44?v=v2" width="677" height="44" role="button" title="shane_spencer_2-1594718479948.jpeg" alt="shane_spencer_2-1594718479948.jpeg" /></span></P><P>it's sorted like below (not the Sum of the Amounts)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="shane_spencer_3-1594718479951.jpeg" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/37398i35F176EB36809F26/image-size/medium?v=v2&amp;px=400" role="button" title="shane_spencer_3-1594718479951.jpeg" alt="shane_spencer_3-1594718479951.jpeg" /></span></P><P>I think the answer maybe something to do with Aggr but I can’t work it out. Any ideas? See attached for sample data.</P> Sat, 16 Nov 2024 18:22:25 GMT https://community.qlik.com/t5/QlikView/Concat-DISTINCT-with-sort-weight/m-p/1727593#M455505 shane_spencer 2024-11-16T18:22:25Z https://community.qlik.com/t5/QlikView/Concat-DISTINCT-with-sort-weight/m-p/1727605#M455506 <P>Try :</P><P>=Concat(Distinct GL_ACCOUNT_CODE_src_1,';', -Fabs(Aggr(<STRONG>NODISTINCT</STRONG> Sum(AMT_NET_TAXREP_src_1),TRANS_INVOICE_NUMBER_src_1,GL_ACCOUNT_CODE_src_1)) )</P> Tue, 14 Jul 2020 09:59:42 GMT https://community.qlik.com/t5/QlikView/Concat-DISTINCT-with-sort-weight/m-p/1727605#M455506 tresB 2020-07-14T09:59:42Z https://community.qlik.com/t5/QlikView/Concat-DISTINCT-with-sort-weight/m-p/1727608#M455507 <P>Thanks - that worked! Are you able to explain what it's doing / why inparticular I need the NODISTINCT ?</P> Tue, 14 Jul 2020 10:07:06 GMT https://community.qlik.com/t5/QlikView/Concat-DISTINCT-with-sort-weight/m-p/1727608#M455507 shane_spencer 2020-07-14T10:07:06Z https://community.qlik.com/t5/QlikView/Concat-DISTINCT-with-sort-weight/m-p/1727625#M455508 <P>Is there a way to do the same in the script?</P> Tue, 14 Jul 2020 10:48:21 GMT https://community.qlik.com/t5/QlikView/Concat-DISTINCT-with-sort-weight/m-p/1727625#M455508 shane_spencer 2020-07-14T10:48:21Z