Bar Chart with Positive and Negatives but Sort by Absolute.

[Anonymous]

We have bar chart with positive and negatives showing.  Fairly simple but they want it sorting by absolute.  I attached a picture of what they want.  So you have 60% and -55% normal due to sorting the 60% would be at the top and negative at the bottom or vice versa.  But in an absolute they would expect the sorting of 60%, -55%, 45%, -33%, etc..  Again showing the negatives.  Is there a way to do that in Qlik Sense.

[sunny_talwar]

May be use a sorting expression:

fabs(ChartExpression)

[Anonymous]

That turns the whole chart into positive.  The means -55% will look like 55%.  That is not what they want.  The display needs to be negative and positive.  The sort is by absolute.

[Anonymous]

I am using QlikSense how would I put in a sorting expression? 

[swuehl]

Set a custom sort expression for the dimension on sort section of the bar chart properties pane: