topic Re: Sorting a Stacked bar chart based on total Value in QlikView

Sorting a Stacked bar chart based on total Value

Anonymous — Mon, 21 Sep 2015 10:27:42 GMT

I have this Stacked bar chart in my Dashboard where I have to sort the chart based on the values ie. 67.44,94.83,112.40....

However, the problem I'm encountering is, It's getting sorted either on the basis of First Expression value (the light colored part) or based on the Dimension.

Would be helpful if someone can throw some light on this.

Thanks.

Re: Sorting a Stacked bar chart based on total Value

Mon, 21 Sep 2015 10:38:43 GMT

Select sort tab under the chart properties and check Y-value option keeping Ascending order in selection.

Re: Sorting a Stacked bar chart based on total Value

lironbaram — Mon, 21 Sep 2015 10:57:14 GMT

in the chart properties

go to the sort tab

check the box sort by expression

and insert your expression in the whit space

select sort in descending order

Re: Sorting a Stacked bar chart based on total Value

Anonymous — Mon, 21 Sep 2015 11:03:44 GMT

Thanks for your reply. I tried that already. However that result yields a chart like this

You can clearly see 3 bars with 2 stacks are not sorted.

Re: Sorting a Stacked bar chart based on total Value

Kushal_Chawda — Mon, 21 Sep 2015 11:05:48 GMT

Go to sort sort tab.

In expression, put below expression

=(Expression1+Expression2)

and select descending

Re: Sorting a Stacked bar chart based on total Value

Kushal_Chawda — Mon, 21 Sep 2015 11:06:33 GMT

please share the sample if possible

Re: Sorting a Stacked bar chart based on total Value

lironbaram — Mon, 21 Sep 2015 11:07:07 GMT

well

this method works for me usually

is your dimension a field or calculated ?

if you put the expression you used to sort in a table with the same dimensions do you get the correct results?

Re: Sorting a Stacked bar chart based on total Value

Anonymous — Mon, 21 Sep 2015 11:17:35 GMT

You were spot on Liron.

1. Field is used as Dimension here.

2. However, when I checked the expression in a table those values were missing.

Reason I can guess is, one of the expression(among the 3) I used is not associated with that field value. Question is, Is there any hack to get it sorted along with other values?

Re: Sorting a Stacked bar chart based on total Value

tresB — Mon, 21 Sep 2015 11:24:15 GMT

Instead of '+' addition use RangeSum(), like:

RangeSum(Exp1, Exp2, Exp3)

Re: Sorting a Stacked bar chart based on total Value

lironbaram — Mon, 21 Sep 2015 11:25:33 GMT

can you post your expression ?

Re: Sorting a Stacked bar chart based on total Value

Anonymous — Mon, 21 Sep 2015 11:27:54 GMT

Thanks Liron and tresesco‌ That was really helpful. rangesum makes it much easier.