Sorting an expression in Descending order

[#1]

Hi Guys,

Can someone help me sort the expression named "instances" in this case in descending order for every month in a chart. There are 2 Dimensions namely "Month" & "Configuration Color".

Attaching the test qvw file + test table file

Thanks

[Kushal_Chawda]

try this sort option

[#3]

I already tried this in different variations! it doesn't work. Tried the "expression" in the sort tab as well!

[swuehl]

Maybe have a look at this thread, if this fulfills your requirements:

Sort Stacked Chart by Y and 2nd Dimension

[sunny_talwar]

Brilliant. I just tried with this as a calculated dimension (similar to Marco's response) and it worked like a charm. I am amazed how you guyz make it so simple

=Dual([Configuration Color], Aggr(instances, Month, [Configuration Color]))

[swuehl]

Yeah, but one remaining issue is that the color legend and the colors are now showing distinct values per combination of Month and Configuration Color. Marco solved this by using a custom coloring and a separate color legend chart  instead of using the bar chart's one.

It would be nice if QV would offer a more simple way of changing the sort order in a stacked bar chart.

For example, it's quite easy to create the correct sort order in a straight table chart.

[#7]

Thanks a lot guys! This helped !

[#8]

Thanks sunny. This worked just fine for me.

[oknotsen]

If your question is now answered, please flag the Correct Answer.

If not, please make clear with what part of this topic you still like help .