Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mic_wang
New 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

1 Solution

Accepted Solutions
Partner
Partner

Re: 2 dimension bar chart - looking to sort by both dimensions

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

quarter in second position

strength in 3rd position and keep its sorting automatic

4 Replies
Partner
Partner

Re: 2 dimension bar chart - looking to sort by both dimensions

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

Highlighted
mic_wang
New Contributor

Re: 2 dimension bar chart - looking to sort by both dimensions

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

Partner
Partner

Re: 2 dimension bar chart - looking to sort by both dimensions

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

quarter in second position

strength in 3rd position and keep its sorting automatic

mic_wang
New Contributor

Re: 2 dimension bar chart - looking to sort by both dimensions

Hi Omar,

 

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