topic Re: Stacked Bar chart presentation in QlikView

Stacked Bar chart presentation

alan_grn — Mon, 23 Feb 2015 13:56:45 GMT

I have a requirement for a stacked bar chart where each of the largest pieces of each stack should be dispalyed at the botom.

Is this possible?

In the attachement the requirement is for James January Sales figures to be at the bottom and then for Johns sales figuires to be at the bottom for February.

Have updated the example

Re: Stacked Bar chart presentation

MK_QSL — Mon, 23 Feb 2015 13:57:48 GMT

Provide sample data... will check and try for you...

Re: Stacked Bar chart presentation

Mon, 23 Feb 2015 14:01:37 GMT

If you know which expressions will be the largest always then you can just order your expressions on the expression tab with the largest expression as the first in the list of expressions.

Re: Stacked Bar chart presentation

MK_QSL — Mon, 23 Feb 2015 14:11:34 GMT

Check enclosed file...

Re: Stacked Bar chart presentation

alan_grn — Mon, 23 Feb 2015 14:19:40 GMT

Thanks. The example that I provided is a bit simplistic.

There is a cyclic group and the top 20 are on the X axis.

Is this still possible? Can try provide a more complex example if required.

Re: Stacked Bar chart presentation

MK_QSL — Mon, 23 Feb 2015 14:32:20 GMT

Better if you can provide some sample data...

Re: Stacked Bar chart presentation

awhitfield — Mon, 23 Feb 2015 16:08:33 GMT

You could sort by the expression you are using e.g. sum(sales) in your example, BUT this works at the whole chart level and not individual columns. There a loads of post on this subject, but the conclusion seems to be it can't be done.