# Qlik Sense App Development

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
New Contributor

## 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.

4 Replies
MVP

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

May be use a sorting expression:

fabs(ChartExpression)

New Contributor

## 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.

New Contributor

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

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

MVP

## 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: