Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Clever_Anjos
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

20 Replies
Not applicable

Can't get it to work either, even tried the Helpdesk Managment app aswell. It seems that the sorting using the whole data set and ignores the TOTAL <[CALL DATE]>

Might be a bug

Not applicable

Maybe this is not what you are looking for but I usually load a sort order table in the load script when using stacked bars.And uncheck all the sorting options for that dimension so it uses the load order.

Clever_Anjos
Employee
Employee
Author

Does not work to me, because every day or hour the scenario can change, I need to show top contributors on top

Maybe Sense 2.0 this month can help me

Clever_Anjos
Employee
Employee
Author

Qlik Sense 2.0 sorts how I need

Capturar.PNG

Not applicable

That looks what I got in 1.1. And is it really correct? Look at the 2 light blue bars with a dark red in the middle. 01/06/2015 the lowest light blue is alot thinner than the one above.

Have you some sort of early access to 2.0? Dying to get my hands on that update, hoping they fixed alot of anoying bugs.

Clever_Anjos
Employee
Employee
Author

That´s correct, because of whole sum of dark red is between two light blues

Not applicable

Capture 2015-06-09.PNG

One other note is that the set analysis you use is not needed when you use TOTAL

sum(CALLS)/sum(total <[CALL DATE]> {<[SWITCH DISPOSITION]=>} CALLS)

=

sum(CALLS)/sum(total <[CALL DATE]> CALLS)

Not applicable

It doesn't work in Qlikview either. Check this reply from mr Cronström.

https://community.qlik.com/message/518298#518298

Clever_Anjos
Employee
Employee
Author

I need because I have to disregard any selections in [SWITCH DISPOSITION]

Capturar.PNG

Clever_Anjos
Employee
Employee
Author

Hi troyansky‌‌, unpacking my copy of your bookIMG_20150820_134819.jpg