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: 
rammuthiah
Creator III
Creator III

Sorting in Bar Chart

I have 2 dimension. I couldn't sort based on measure. In QV, have done, but not in Qlik Sense.

Sorting.jpg

10 Replies
vinieme12
Champion III
Champion III

Are you sure you are using Sort by Measure?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
rammuthiah
Creator III
Creator III
Author

Yes. Because of 2 dimension, it is not working

OmarBenSalem

In the sort tab; put ur measure in the first row (above everything)

agigliotti
Partner - Champion
Partner - Champion

please attach your bar chart sorting settings.

anyway you should choose "Sort by expression" for your dimension.

rammuthiah
Creator III
Creator III
Author

I tried using match function in expression for Dimension. If some days later, any value increases that what we have given, then it will create problem.

rammuthiah
Creator III
Creator III
Author

We can't move the measures in the first row.

vijetas42
Specialist
Specialist

I don't think it will work with two dimensions.and changing sort order for dimension and measure is only possible with single dimension.

agigliotti
Partner - Champion
Partner - Champion

you can sort by expression (your measure).

mukesh19
Contributor II
Contributor II

That  sorting issue is because of the null values if you include the null values you can eliminate that issue. If you don't want the null values in the sortby expression eliminate the null values in the second  dimension then you can solve the problem.

dimension 1: X, Dimension 2: A

eg: aggr(count( distinct {<-={"=isnull()"}>} B),X,A)