Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
micheledenardi
Specialist II
Specialist II

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

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
Labels (1)
1 Solution

Accepted Solutions
micheledenardi
Specialist II
Specialist II
Author

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

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

4 Replies
Ruggero_Piccoli
Support
Support

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
Specialist II
Specialist II
Author

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....

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Specialist II
Specialist II
Author

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

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.