topic Re: Bar chart sort issue in QlikView

Bar chart sort issue

cmano — Sat, 27 Aug 2022 06:39:59 GMT

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?

thank you.

BrunPierre — Sat, 27 Aug 2022 07:30:05 GMT

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

cmano — Sat, 27 Aug 2022 07:42:54 GMT

I need to write something in expression?.

If yes what i should?

Thank you

BrunPierre — Sat, 27 Aug 2022 07:55:42 GMT

The same calculation under the expressions window.

Sort by expression

cmano — Sat, 27 Aug 2022 07:56:23 GMT

In this case?

BrunPierre — Sat, 27 Aug 2022 09:31:33 GMT

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 — Sat, 27 Aug 2022 09:05:49 GMT

Its dynamic.

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

Again thank you for your help