Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rammuthiah
Contributor II

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

Tags (1)
9 Replies
vinieme12
Esteemed Contributor II

Re: Sorting in Bar Chart

Are you sure you are using Sort by Measure?

rammuthiah
Contributor II

Re: Sorting in Bar Chart

Yes. Because of 2 dimension, it is not working

omarbensalem
Esteemed Contributor

Re: Sorting in Bar Chart

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

agigliotti
Honored Contributor II

Re: Sorting in Bar Chart

please attach your bar chart sorting settings.

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

rammuthiah
Contributor II

Re: Sorting in Bar Chart

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
Contributor II

Re: Sorting in Bar Chart

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

vijetasharma
Contributor III

Re: Sorting in Bar Chart

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
Honored Contributor II

Re: Sorting in Bar Chart

you can sort by expression (your measure).

mukesh19
New Contributor II

Re: Sorting in Bar Chart

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)