Stacked Bar Max Visible Error

Wed, 10 Aug 2011 21:24:19 GMT

Hi All,

I built a stacked bar graph and would like to show values for the top 10 categories while putting all the rest into an "Other" bucket. When I selected Max Visible Number = 10 and checked Show Others on the Presentation tab, I got this as a result:

The crazy stacked blue bars are "Other" and definitely not correct. The formula is set up as a contribution to growth formula:

(This year amount for category - last year amount for category)

/ Last year total amount

Has anyone come across this before? Is there any solution? I've tried using Aggr functions but maybe I'm not putting them in the correct spots.

Thanks,

Claire

topic Stacked Bar Max Visible Error in QlikView

Stacked Bar Max Visible Error