4 Replies Latest reply: Jun 17, 2016 4:29 PM by Stefan Wühl

# Bar Chart with Positive and Negatives but Sort by Absolute.

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.

• ###### Re: Bar Chart with Positive and Negatives but Sort by Absolute.

May be use a sorting expression:

fabs(ChartExpression)

• ###### Re: Bar Chart with Positive and Negatives but Sort by Absolute.

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.

• ###### Re: Bar Chart with Positive and Negatives but Sort by Absolute.

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

• ###### Re: Bar Chart with Positive and Negatives but Sort by Absolute.

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