Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
escarber
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.

IMG_0651.jpg

4 Replies

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

May be use a sorting expression:

fabs(ChartExpression)

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

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

2016-06-17 22_28_15-APPLE_2016_04 - Excel.png

Community Browser