topic Sort A-Z from two flied simultaneously. in QlikView

Sort A-Z from two flied simultaneously.

Sxbbb — Fri, 15 Nov 2024 21:48:56 GMT

Want to sort WorkOrder &'-'& SampleNo

SampleNo from ascending

Now SampleNo is not sorted ascending.

I want to sort SampleNo in every WorkOrder.

like this

Re: Sort A-Z from two flied simultaneously.

marcus_sommer — Thu, 16 Feb 2023 13:12:11 GMT

By concatenating the fields the sample-no isn't a numeric anymore else a string-part and sorted in this way. You may get your wanted sort-order by adding extra zero's, maybe like:

field1 & num(field2, '00')

Re: Sort A-Z from two flied simultaneously.

Sxbbb — Mon, 20 Feb 2023 02:00:46 GMT

It got results like this.

Still not the way you want

Re: Sort A-Z from two flied simultaneously.

marcus_sommer — Mon, 20 Feb 2023 08:07:41 GMT

I meant to apply the adjusted concatenation within the dimension and not as sort-expression which couldn't work in this way because it creates a string and nothing what could be numerically evaluated. If you want to keep it as sort-expression you need extend the approach, maybe with: maxstring().

Re: Sort A-Z from two flied simultaneously.

Sxbbb — Tue, 21 Feb 2023 03:16:24 GMT

I used Code

SampleNo from ascending

Re: Sort A-Z from two flied simultaneously.

Sxbbb — Tue, 21 Feb 2023 03:18:15 GMT

I followed the previous thread

https://community.qlik.com/t5/QlikView-App-Dev/I-want-add-Value-0-to-SampleNo/td-p/2034695

Re: Sort A-Z from two flied simultaneously.

Sxbbb — Tue, 21 Feb 2023 03:18:39 GMT

How do I fix it so that it's in ascending order?

Re: Sort A-Z from two flied simultaneously.

marcus_sommer — Tue, 21 Feb 2023 07:16:04 GMT

Just follow the suggestions from above!

Beside this I recommend to transfer most of the logic into the script to avoid any challenges with calculated dimensions.