开云体育

ctrl + shift + ? for shortcuts
© 2025 开云体育
  1. DXLab
  2. Topics

Wrong Band sort in DXKeeper's User-defined sorts

 

Hi,
?
I defined this sort in the "DXKeeper Advanced Sorts, Filters & Modifieres"
window:
?
First item: STATE
Second item: Band
Third item: Mode
?
all three in ascending order. Applying this sort it seems the Band column
is in plain alphabetical order within the same STATE, like
?
12M
160M
2M
40M
80M
?
but I think it should be ordered like this
?
2M
12M
40M
80M
160M
?
as it is when I double click the Band column in DXKeepers "Log QSOs" table.
?
Or do I miss something?
?
73,
Lui, DL6FBR
 

Or do I miss something?
Use val(Band) to sort numerically instead of alpha.

The use of "val()" is not documented, AFAIK.

73,

... Joe, W4TV


On 2025-03-03 5:21 AM, Ludwig Hechler, DL6FBR via groups.io wrote:
Hi,
I defined this sort in the "DXKeeper Advanced Sorts, Filters & Modifieres"
window:
First item: STATE
Second item: Band
Third item: Mode
all three in ascending order. Applying this sort it seems the Band column
is in plain alphabetical order within the same STATE, like
12M
160M
2M
40M
80M
but I think it should be ordered like this
2M
12M
40M
80M
160M
as it is when I double click the Band column in DXKeepers "Log QSOs" table.
Or do I miss something?
73,
Lui, DL6FBR
 


You might sort by frequency instead of band.

Vy 7 3
Earl / KD5XB
DM84

e e

Sent with secure email.

On Monday, March 3rd, 2025 at 3:21 AM, Ludwig Hechler, DL6FBR via groups.io <L.Hechler@...> wrote:

Hi,
?
I defined this sort in the "DXKeeper Advanced Sorts, Filters & Modifieres"
window:
?
First item: STATE
Second item: Band
Third item: Mode
?
all three in ascending order. Applying this sort it seems the Band column
is in plain alphabetical order within the same STATE, like
?
12M
160M
2M
40M
80M
?
but I think it should be ordered like this
?
2M
12M
40M
80M
160M
?
as it is when I double click the Band column in DXKeepers "Log QSOs" table.
?
Or do I miss something?
?
73,
Lui, DL6FBR
 

Joe, good tip! The val(Band) works fine.
Thank you
Lui
 

+ AA6YQ comments below
Use val(Band) to sort numerically instead of alpha.

The use of "val()" is not documented, AFAIK.
+ The 4th paragraph of

?
+ suggested using the ABS function, applying it to the DXCCID field as an example. I changed this to the more understandable VAL function, and added a sentence suggesting its use to numerically sort by band.

+ Thanks!

? ? ? ?73,

? ? ? ? ? Dave, AA6YQ

1 - 5 of 5