topic Sorting Stacked Chart in QlikView

Sorting Stacked Chart

Fri, 24 Oct 2014 21:03:05 GMT

I have a chart with the following Dimensions:

My Expression is:

Sum(FreightCosts)

My graph looks like:

I want it to sort the lowest value on top (Misc) and Highest on bottom (Freight). I have tried everything and can't get it to work.

Please help.

Re: Sorting Stacked Chart

MarcoWedel — Fri, 24 Oct 2014 22:29:22 GMT

Hi Amanda,

one solution might be to use Sum(FreightCosts) as a sorting expression as well. The order can be defined once for the whole chart, not per bar though, i.e. the order is defined by the total costs per category:

hope this helps

regards

Marco

Re: Sorting Stacked Chart

Tue, 28 Oct 2014 16:00:28 GMT

The SUM Freight function still isn't working. Here is what it looks like now:

The Red section (Misc) is now all over the place.

Re: Sorting Stacked Chart

ashfaq_haseeb — Tue, 28 Oct 2014 16:08:09 GMT

Hi go to sort tab and select sort by y value ascending for both dimensions.

Regards

ASHFAQ

Re: Sorting Stacked Chart

morganaaron — Tue, 28 Oct 2014 16:11:00 GMT

Hi Amanda,

Try using =Rank(Sum(FreightCosts)) for the expression for Category in the sort tab and set to Ascending.

Re: Sorting Stacked Chart

Tue, 28 Oct 2014 16:14:07 GMT

Okay... so the Sum(FreightCosts) is actually working. I reviewed my data, and apparently some of my freight (misc) is negative.

SO, it is sorting correctly!

Thanks All.

Amanda

Re: Sorting Stacked Chart

Tue, 28 Oct 2014 16:17:52 GMT

Amanda i see that you are new here so please take the time to mark Marco's answer as correct answer