Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
IMPORTANT: PLEASE READ - Labels will be required in the NPrinting forum starting on Friday September 26, 2019: Click here for details and instructions.
micheledenardi
Valued Contributor

Pixel Perfect Combo Chart X Axis Wrong Sort Order

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.

2019-03-27 14_29_22-Report_ SSVI Sales Agent Report.pdf.png

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

2019-03-27 14_33_36-Series Collection Editor.png

1 Solution

Accepted Solutions
micheledenardi
Valued Contributor

Re: Pixel Perfect Combo Chart X Axis Wrong Sort Order

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

4 Replies
Employee
Employee

Re: Pixel Perfect Combo Chart X Axis Wrong Sort Order

Hi,

Please check if the following articles can help you:

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
micheledenardi
Valued Contributor

Re: Pixel Perfect Combo Chart X Axis Wrong Sort Order

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

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)
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
micheledenardi
Valued Contributor

Re: Pixel Perfect Combo Chart X Axis Wrong Sort Order

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