Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 II
Partner - Master II

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 II
Partner - Master II

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 II
Partner - Master II

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