Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-08-10 05:24 PM

Stacked Bar Max Visible Error

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:

Other Error.png

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

559 Views
0 Likes
0 Replies