Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 dimension. I couldn't sort based on measure. In QV, have done, but not in Qlik Sense.
Are you sure you are using Sort by Measure?
Yes. Because of 2 dimension, it is not working
In the sort tab; put ur measure in the first row (above everything)
please attach your bar chart sorting settings.
anyway you should choose "Sort by expression" for your dimension.
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.
We can't move the measures in the first row.
I don't think it will work with two dimensions.and changing sort order for dimension and measure is only possible with single dimension.
you can sort by expression (your measure).
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)