topic Re: Sort with expression in QlikView

Sort with expression

Wed, 20 Jun 2012 16:19:32 GMT

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!

Re: Sort with expression

erichshiino — Wed, 20 Jun 2012 17:03:35 GMT

Hi,

Try a sort expression similar to this:

= min({1} AgeGroup)

= minstring( {1} AgeGroup)

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

Hope it helps,

Erich

Re: Sort with expression

Thu, 21 Jun 2012 07:28:02 GMT

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.