Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Employee
Employee

Bar chart sorting

I´m using a stacked bar chart with two dimensions

Capturar.PNG

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

Capturar2.PNG

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

Capturar3.PNG

1 Solution

Accepted Solutions
MVP
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
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
Employee

Re: Bar chart sorting

Very nice idea, but it´s not working yet

Capturar.PNG

Employee
Employee

Re: Bar chart sorting

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

MVP
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
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
Employee

Re: Bar chart sorting

Same result.

Attaching my file

Community Browser