Ordering Stacked Bar Chart

[#1]

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

[#2]

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.

[jsingh71]

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.

[#4]

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.

[#5]

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

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

[antoniotiman]

In Propery -> Sort You select Order .

Regards

[ashwanin]

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.

[#8]

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 ?

[#9]

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

[jsingh71]

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