topic Re: Ordering Stacked Bar Chart in Water Cooler

Ordering Stacked Bar Chart

Tue, 18 Mar 2014 10:30:05 GMT

Hi everyone,

I have a stacked bar chart with time on the x-axis and a count of different names on the y. I want to re-order the stack on each bar according to something I specify. At the moment QV is ordering the stack components according to some automatic stacking process by default.

Thank you

Re: Ordering Stacked Bar Chart

Tue, 18 Mar 2014 10:53:20 GMT

Assuming the stack ordering defaults to the following, I would like to override the order so that YX is at the top, followed by GY, YY and XG.

Re: Ordering Stacked Bar Chart

jsingh71 — Tue, 18 Mar 2014 11:01:16 GMT

Hi,

Go to chart properties and then expression. You rearrenge your expreesion in the way you want to show in your chart.

The first(top) expreesion which you select in expreesion , it will be the lowest color in bar.

Re: Ordering Stacked Bar Chart

Tue, 18 Mar 2014 11:07:22 GMT

Hi,

Thank you for your response. I only have one dimension, which is a re-scaling of the y-axis values. So Promote button is greyed out.

Re: Ordering Stacked Bar Chart

Tue, 18 Mar 2014 11:11:03 GMT

I have 2 dimensions: i) time and ii) category (paired letters)

In the Expressions tab, all I have is the values (Y-axis) / 1000

Re: Ordering Stacked Bar Chart

antoniotiman — Tue, 18 Mar 2014 11:13:23 GMT

In Propery -> Sort You select Order .

Regards

Re: Ordering Stacked Bar Chart

ashwanin — Tue, 18 Mar 2014 11:20:13 GMT

you need to do the shorting of values of field which you have used in Dimension in script level

here YX should be 1 and then so on .

Reload and then do shorting in the graph.

Re: Ordering Stacked Bar Chart

Tue, 18 Mar 2014 11:22:21 GMT

The Ordering options are Original and Reversed, but I want to order according to a custom sequence. That doesn't seem to be possible from what I can see. Is there a way to enter an expression so that the ordering is as follows:

YX at the top, followed by GY, YY and XG ?

Re: Ordering Stacked Bar Chart

Tue, 18 Mar 2014 11:23:24 GMT

Thanks Ashwani, When you say script level, do you mean I have to order the raw data before loading?

Re: Ordering Stacked Bar Chart

jsingh71 — Tue, 18 Mar 2014 11:42:04 GMT

You can add dimension as a expression in expression tab...after that you'll do pramote and demote.

Re: Ordering Stacked Bar Chart

ashwanin — Tue, 18 Mar 2014 12:32:30 GMT

Yes You need to inline the values that what you required.

Re: Ordering Stacked Bar Chart

ashwanin — Tue, 18 Mar 2014 12:34:48 GMT

LOAD * INLINE [

Value Rank

YZ 1

GY 2

YY 3

GY 4] ; and then do shorting in Graph.