topic Bar Chart with Positive and Negatives but Sort by Absolute. in App Development

Bar Chart with Positive and Negatives but Sort by Absolute.

Anonymous — Fri, 17 Jun 2016 18:19:54 GMT

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.

sunny_talwar — Fri, 17 Jun 2016 18:28:20 GMT

May be use a sorting expression:

fabs(ChartExpression)

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

Anonymous — Fri, 17 Jun 2016 18:37:07 GMT

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.

Anonymous — Fri, 17 Jun 2016 19:33:31 GMT

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

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

swuehl — Fri, 17 Jun 2016 20:29:35 GMT

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