Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
cmano
Creator
Creator

Bar chart sort issue

Dear all.

As you can see below i want to sort the values with descending order but the bar at right is bigger than the middle one 

Any suggestion?

Screenshot 2022-08-27 093400.png

Screenshot 2022-08-27 093422.png

Screenshot 2022-08-27 093436.png

   thank you.

Labels (2)
6 Replies
BrunPierre
Partner - Master
Partner - Master

Try using the sort by expression in descending order. You will have to uncheck the others.

cmano
Creator
Creator
Author

I need to write something in expression?.

If yes what i should?

Thank you

BrunPierre
Partner - Master
Partner - Master

The same calculation under the expressions window.

peter_brown_0-1661586570371.png

Sort by expression

peter_brown_1-1661586862315.png

 

 

cmano
Creator
Creator
Author

In this case?

Screenshot 2022-08-27 105415.png

BrunPierre
Partner - Master
Partner - Master

Perhaps use the expression that's always likely to give the maximum value for the sorting.

Also, promote that very expression to the first under the expressions windows.

Hope it helps.

 

 

 

cmano
Creator
Creator
Author

Its dynamic.

This time i have 3 values the next month i will have more or less.

Again thank you for your help