Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be use a sorting expression:
fabs(ChartExpression)
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.
I am using QlikSense how would I put in a sorting expression?
Set a custom sort expression for the dimension on sort section of the bar chart properties pane: