topic Re: Customer sort order doesn't work in QlikView

Customer sort order doesn't work

nicogene — Thu, 29 Jan 2015 15:40:31 GMT

Dear all,

With list box object, the custom sort order doesn't work.

The formula used: Only({1} Match(Month,'01','02','03','04','05','06','07','08','09''10','11','12'))

And an example in attachment.

Many thanks in advance for your help.

Kindest regards,

Nicolas.

Re: Customer sort order doesn't work

Anonymous — Thu, 29 Jan 2015 16:03:05 GMT

You just lost a comma between 9 and 10.

Try to insert it!

Elena

Re: Customer sort order doesn't work

Anonymous — Thu, 29 Jan 2015 16:05:05 GMT

Hi,

Comma is missing between 09 and 10

Try:

Only({1} Match(Month,'01','02','03','04','05','06','07','08','09','10','11','12'))

Re: Customer sort order doesn't work

nicogene — Thu, 29 Jan 2015 16:13:38 GMT

Thanks but the problem is still present.

Kindest regards,

Nicolas.

Re: Customer sort order doesn't work

Anonymous — Thu, 29 Jan 2015 16:17:36 GMT

This sholud be correct (without 0)

Only({1} Match(Month,'1','2','3','4','5','6','7','8','9','10','11','12'))

Re: Customer sort order doesn't work

nicogene — Thu, 29 Jan 2015 16:20:14 GMT

Thanks for your response.

It works but I don't understand why it doesn't work with 01, 02 etc.

Kindest regards,

Nicolas.

Re: Customer sort order doesn't work

Anonymous — Thu, 29 Jan 2015 16:22:25 GMT

Because your field Month have values without 0 and for this reason match function didn't work.

Elena

Re: Customer sort order doesn't work

nicogene — Thu, 29 Jan 2015 16:24:20 GMT

Ok thanks for your time.

Kindest regards,

Nicolas.

Re: Customer sort order doesn't work

MarcoWedel — Thu, 29 Jan 2015 16:31:28 GMT

Hi,

another solution could be to replace the line

    [Month Name],

in the load statement of your sales table with

Month(Date#([Month Name],'MMM')) as [Month Name],

to use numerical sorting instead and to forget about sorting expressions.

To get the same month names as before, you may have to redefine your MonthNames variable as well.

hope this helps

regards

Marco