Bar chart sorting

[Clever_Anjos]

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?

[Oleg_Troyansky · Accepted solution]

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.

[Clever_Anjos]

Very nice idea, but it´s not working yet

[Clever_Anjos]

Pre-ordering your new book, I´m your fan

[Oleg_Troyansky]

Thanks, Clever Anjos!

[#6]

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

[Clever_Anjos]

Does not work either

[#8]

Try it with the expression of Distruibuição

[#9]

And put Switch Disposition above Distruibuição

[Clever_Anjos]

Same result.

Attaching my file