topic Ordering in a stacked bar chart in QlikView

Ordering in a stacked bar chart

Sunil_Kenth — Fri, 09 Sep 2011 11:22:11 GMT

Is it possible to order the sections in a stacked bar chart? I would like to display the largest sections at the bottom?

Here are the details of my chart:

Dimension1 = no_in_basket

Dimension2 = product group

Expression = count(distinct ReceiptID)

Sort order = no_in_basket, Y Value Descending

Thanks for your help.

Sunil

Ordering in a stacked bar chart

Miguel_Angel_Baeyens — Fri, 09 Sep 2011 11:37:56 GMT

Hi Sunil,

Assuming that what you have is a chart with one dimension and several expressions, and those expressions being stacked, you can sort by Y-Value and then promote and demote the expressions from the higher to the lower: the upper the expression is, the lower it appears in the Expressions tab in the chart properties.

Is that what you are looking for?

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Ordering in a stacked bar chart

Sunil_Kenth — Tue, 27 Sep 2011 10:19:05 GMT

Hi Miguel,

Thanks for your help on this and apologies for my delay in replying. I only have 1 expression and 2 dimensions. When i look at the sort tab in the properties of the stacked bar chart, i can only apply a sort on the these 2 dimensions. The question i have is, what sort type do i need to apply in order for the stacks in the bar chart to display the highest amounts at the bottom of the bar and lowest amounts at the top of the bar.

Thanks,

Sunil