Sort with expression

[#1]

Hi.

I use a expression to sort one of my charts and it´s looks god. But when you do a selection from i.e. a multibox the charts change sort order, se atached pictures. It looks like then there is no value for the field QV doesen´t care about the sort order. If I change to another one like text or numeric value it´s works like it should do, but for me in wrong sort order.

I use =MixMatch(AgeGroup, '0 - 17', '18 - 24', '25 - 29', '30 - 34', '35 - 39', '40 - 44', '45 - 49', '50 - 54'......)

Any one that have a good solution?

Thanks!

[erichshiino]

Hi,

Try a sort expression similar to this:

= min({1} AgeGroup)

or

= minstring( {1} AgeGroup)

This expression should calculate a value for the sort order independently of your selections.

Hope it helps,

Erich

[#3]

hi,

you can use Dual() Function to sort the order.

You need to pass a no sequence to sort the age group.

put dual at place where u have derived the age group.