# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Employee

## Bar chart sorting

I´m using a stacked bar chart with two dimensions

and I would like to sort based on the expression value (Distruibuição)

Unfortunately, the bars are not beeing sorted as I want. Any ideas?

1 Solution

Accepted Solutions
MVP

## Re: Bar chart sorting

Hi,

I haven't faced this particular problem, however I recall solving another sorting problem in a Scatter chart. Unfortunately, Scatter charts can't be sorted in Qlik Sense. To overcome the problem, I created a calculated Dimension using Dual() and assigned the numeric portion of the dual value based on my sorting expression. This trick worked, and my dimension was sorted based on the numeric value.

Try the same here, it might work in a similar way.

cheers,

Oleg Troyansky

QlikView Your Business - check out my new book about QlikView and Qlik Sense. Coming out in August.

20 Replies
MVP

## Re: Bar chart sorting

Hi,

I haven't faced this particular problem, however I recall solving another sorting problem in a Scatter chart. Unfortunately, Scatter charts can't be sorted in Qlik Sense. To overcome the problem, I created a calculated Dimension using Dual() and assigned the numeric portion of the dual value based on my sorting expression. This trick worked, and my dimension was sorted based on the numeric value.

Try the same here, it might work in a similar way.

cheers,

Oleg Troyansky

QlikView Your Business - check out my new book about QlikView and Qlik Sense. Coming out in August.

Employee

## Re: Bar chart sorting

Very nice idea, but it´s not working yet

Employee

MVP

## Re: Bar chart sorting

Thanks, Clever Anjos!

Not applicable

## Re: Bar chart sorting

I am not sure I get what you are after but, I would try sorting Switch Disposition with the expression '=Column(1)'.

Hope it helps

//Karl

Employee

## Re: Bar chart sorting

Does not work either

Not applicable

## Re: Bar chart sorting

Try it with the expression of Distruibuição

Not applicable

## Re: Bar chart sorting

And put Switch Disposition above Distruibuição

Employee

## Re: Bar chart sorting

Same result.

Attaching my file