topic Re: Re: stacked bar chart sort order in QlikView

stacked bar chart sort order

mambi — Mon, 28 Apr 2014 14:08:49 GMT

Hi everyone,

in the chart below i've 2 dimensions : 1st : Category, 2nd Product and 1 expression : sum(Qt) / sum( total <Category> Qt)

i'm trying to sort products in each bar by descending order of Qt , so in the sort tab i used this expression : sum(Qt) / sum( total <Category> Qt) but it's doesn't work.

(the category order is not important)

any idea?

Re: stacked bar chart sort order

bbi_mba_76 — Mon, 28 Apr 2014 14:12:48 GMT

Hi,

it is better if you upload the document. Maybe you could try to sort using only sum(Qt)

Re: stacked bar chart sort order

Anonymous — Mon, 28 Apr 2014 14:24:19 GMT

Well, it is in fact sorted by the descending order - but in total rather than per Category. It maybe possible to have different sort order per Category. As Michele Barini says, upload your file.

Re: Re: stacked bar chart sort order

mambi — Mon, 28 Apr 2014 14:32:19 GMT

here's an exemple :

as you can see the 2nd,3rd ... bars are not well ordered

also i want to use persistent colors option

Re: stacked bar chart sort order

hic — Tue, 29 Apr 2014 11:10:56 GMT

The sort order is calculated globally for the chart. Since the product 'SCG' is ranked 2nd on a global level, it will be the 2nd product in all categories.

There is unfortunately no simple way to have different sort orders for the different categories. Maybe it can be done using Aggr(Rank(Sum(...))) as calculated dimension, and then sorted according to this. I haven't tried it though...

HIC

Re: stacked bar chart sort order

mambi — Tue, 29 Apr 2014 11:22:08 GMT

thanks for your time

Re: stacked bar chart sort order

Anonymous — Tue, 29 Apr 2014 12:02:08 GMT

I tried this and other similar but didn't find a solution.