topic Re: Pixel Perfect Combo Chart X Axis Wrong Sort Order in Qlik NPrinting

Pixel Perfect Combo Chart X Axis Wrong Sort Order

micheledenardi — Wed, 25 Sep 2019 18:40:54 GMT

Dear all,

how can i fix the sort order of my Feb 2019 pixel perfect combo chart ?

Actually is displayed like below (1,10,11,12,2,3,4,5...) and i want to sort numerically so, 1,2,3,4....,9,10,11,12.

I've selected the sord order by argyment but i don't know if is the correct option...

Re: Pixel Perfect Combo Chart X Axis Wrong Sort Order

Ruggero_Piccoli — Wed, 27 Mar 2019 13:54:44 GMT

Hi,

Please check if the following articles can help you:

Best Regards,

Ruggero

Re: Pixel Perfect Combo Chart X Axis Wrong Sort Order

micheledenardi — Wed, 27 Mar 2019 14:05:42 GMT

I've already read that articles but i can't find a way to sort my dimension (which is a number) in the proper way.... it seems i can order it numerically (so 1,10,11,12,2,3,4,5....) and by measures values but is not what i want... i just need to sort it by ascending dimension value....

Re: Pixel Perfect Combo Chart X Axis Wrong Sort Order

Lech_Miszkiewicz — Wed, 27 Mar 2019 21:54:41 GMT

By looking at the way it is sorted it seems like your dimension is sorted as text so i guess it is set as auto or gualitative argument in data series binding properties (try to set it to numerical there-it is different setting to what you have on your screenshot)

Re: Pixel Perfect Combo Chart X Axis Wrong Sort Order

micheledenardi — Thu, 28 Mar 2019 08:03:01 GMT

Finally i resolved by formatting the dimension as text (01,02,03...10,11,12).