topic Re: Sorting an expression in Descending order in QlikView

Sorting an expression in Descending order

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Sorting an expression in Descending order

Kushal_Chawda — Sat, 18 Jun 2016 10:10:51 GMT

try this sort option

Re: Sorting an expression in Descending order

Sat, 18 Jun 2016 10:15:01 GMT

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

Re: Sorting an expression in Descending order

swuehl — Sat, 18 Jun 2016 11:13:08 GMT

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

Sort Stacked Chart by Y and 2nd Dimension

Re: Sorting an expression in Descending order

sunny_talwar — Sat, 18 Jun 2016 14:01:07 GMT

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]))

Re: Sorting an expression in Descending order

swuehl — Sat, 18 Jun 2016 15:10:14 GMT

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.

Re: Sorting an expression in Descending order

Fri, 24 Jun 2016 06:44:23 GMT

Thanks a lot guys! This helped !

Re: Sorting an expression in Descending order

Fri, 24 Jun 2016 07:06:02 GMT

Thanks sunny. This worked just fine for me.

Re: Sorting an expression in Descending order

oknotsen — Fri, 24 Jun 2016 08:18:10 GMT

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 .