Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mic_wang
Contributor
Contributor

2 dimension bar chart - looking to sort by both dimensions

Hi Everyone,

I have 2 dimensions, Product Strength and Quarter. The measure column has number of production runs. I'd like to sort my X axis (dimensions) by strength from smallest to largest (already done). However, I am having trouble adding another sort that makes the Quarter go Q1,Q2,Q3,Q4... in order. 

Does anyone know how to add an additional sort? Kindly let me know if I can clarify anything

Thanks all,

Wang

Labels (4)
1 Solution

Accepted Solutions
OmarBenSalem

Put the sum(measure) in first position (drag it)

quarter in second position

strength in 3rd position and keep its sorting automatic

View solution in original post

4 Replies
OmarBenSalem

In the sorting Tab; go to quarters and sort it by Alphabet asc

mic_wang
Contributor
Contributor
Author

Hi Omar, 

I'm currently trying this solution but the issue still remains - please see attached screen shot. Do you know any other potential fixes?

 

Thanks again

OmarBenSalem

Put the sum(measure) in first position (drag it)

quarter in second position

strength in 3rd position and keep its sorting automatic

mic_wang
Contributor
Contributor
Author

Hi Omar,

 

Thanks for the suggestion - I made the attached changes for the solution.