QlikView sorts the values ​​not in the correct alphabetical sequence

[#1]

QlikView sorts the values ​​on the x - axis not in the correct alphabetical sequence. (in chart diagram)

In the sort setting, I have selected only alphabetical order A-Z.

This is the order what I expect:

SG57 Prikuss

SG5810 Bankenportal

SG98 Edm

This is, how qlikview sort the values:

SG57 Prikuss

SG98 Edm

SG5810 Bankenportal

Why ? Any Workaround ?

Thanks.

[sunny_talwar]

Would you be able to share a sample where it is not working? You can use a sort expression like this, but I would still think that Text sorting should work

Match(FieldName, 'SG57 Prikuss', 'SG98 Edm', 'SG5810 Bankenportal')

[Kushal_Chawda]

try sort expression instead alphabetical sorting

=match(Field,

'SG57 Prikuss' ,

'SG5810 Bankenportal',

'SG98 Edm')

[sunny_talwar]

But why would text sorting won't work kushal

[MarcoWedel]

Hi,

maybe helpful:

Listbox - text sort not ASCII?

Sorting Fields with special characters

regards

Marco

[MarcoWedel]

Edit: Doesn't work

Hi,

one solution could be to use your fieldname as sorting expression:

hope this helps

regards

Marco

[swuehl]

What happens if you are using a load order that is not well sorted, Marco ?

[MarcoWedel]

Good one.

Guess I should have read the linked threads myself.

thanks

Marco

[swuehl]

What about this?

[MarcoWedel]

very good

and interesting too

just was about to post this when I read your answer ...

At first I tried with some conversion to concatenated ASCII codes

when I noticed that Rank descending would be sufficient.

thanks

regards

Marco